×
Discuss about Upgrade, What are the pre-requesties, Scoping, Actual Upgrade, Upgrade Testing, Technical Testing, Functional Testing, Local code conversion, Core upgrade, Local upgrade, etc…
ENQUIRY.SELECT EXCEPTION : List of Unauthorised file
- F@b
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 17
- Thank you received: 0
4 months 1 week ago #24648
by F@b
ENQUIRY.SELECT EXCEPTION : List of Unauthorised file was created by F@b
Hi,
I would like to extract the list of unauthorized file from command line (OFS message) and save it in a file. Is this possible? if so, how can I set it up.
Thank you for your advice
I would like to extract the list of unauthorized file from command line (OFS message) and save it in a file. Is this possible? if so, how can I set it up.
Thank you for your advice
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1200
- Thank you received: 158
4 months 5 days ago #24650
by VK
Cheers
VK
Replied by VK on topic ENQUIRY.SELECT EXCEPTION : List of Unauthorised file
Hi
you can use ENQUIRY.SELECT in OFS message in application place.
you can use ENQUIRY.SELECT in OFS message in application place.
Cheers
VK
Please Log in or Create an account to join the conversation.
- F@b
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 17
- Thank you received: 0
1 month 3 days ago - 1 month 3 days ago #24737
by F@b
Replied by F@b on topic ENQUIRY.SELECT EXCEPTION : List of Unauthorised file
Hi,
I use this command to extract all the exception :
sh DBTools -u TOTO -p 1223 -s OFS ENQUIRY.SELECT,,INPUTT/12xxxx,EXCEPTION
The output looks like this:
"F.EB.DICTIONARY " " 65" " 65" " 0" " 0" " 0" " 0" " 0"
"F.EB.ERROR " " 11" " 11" " 0" " 0" " 0" " 0" " 0"
"F.EB.MAPPING.SOURCE " " 3" " 3" " 0" " 0" " 0" " 0" " 0"
"F.EB.PRODUCT " " 1" " 1" " 0" " 0" " 0" " 0" " 0"
"F.ENQUIRY " " 9" " 0" " 0" " 0" " 0" " 0" " 9"
Is it possible to filter or sort according to IHAU or IHLD status?
I would like the output to also show me a status (IHAU or IHLD) column
Thanks for your support
I use this command to extract all the exception :
sh DBTools -u TOTO -p 1223 -s OFS ENQUIRY.SELECT,,INPUTT/12xxxx,EXCEPTION
The output looks like this:
"F.EB.DICTIONARY " " 65" " 65" " 0" " 0" " 0" " 0" " 0"
"F.EB.ERROR " " 11" " 11" " 0" " 0" " 0" " 0" " 0"
"F.EB.MAPPING.SOURCE " " 3" " 3" " 0" " 0" " 0" " 0" " 0"
"F.EB.PRODUCT " " 1" " 1" " 0" " 0" " 0" " 0" " 0"
"F.ENQUIRY " " 9" " 0" " 0" " 0" " 0" " 0" " 9"
Is it possible to filter or sort according to IHAU or IHLD status?
I would like the output to also show me a status (IHAU or IHLD) column
Thanks for your support
Last edit: 1 month 3 days ago by F@b.
Please Log in or Create an account to join the conversation.
- VK
-
- Offline
- Platinum Member
-
- Globus:G9-G13|TAFC:R05-R23|TAFJ:R19,R23,R24:test
Less
More
- Posts: 1200
- Thank you received: 158
1 month 3 days ago #24738
by VK
Cheers
VK
Replied by VK on topic ENQUIRY.SELECT EXCEPTION : List of Unauthorised file
Hi
to limit output:
To show more fields in the output - edit ENQUIRY EXCEPTION or create your own one on its base.
to limit output:
...,EXCEPTION,RECORD.STATUS:EQ:=INAUTo show more fields in the output - edit ENQUIRY EXCEPTION or create your own one on its base.
Cheers
VK
The following user(s) said Thank You: F@b
Please Log in or Create an account to join the conversation.
- F@b
- Topic Author
- Offline
- New Member
-
Less
More
- Posts: 17
- Thank you received: 0
1 month 3 days ago #24739
by F@b
Replied by F@b on topic ENQUIRY.SELECT EXCEPTION : List of Unauthorised file
Thank you
Please Log in or Create an account to join the conversation.
Time to create page: 0.086 seconds