In omvs on z/OS 1.9, used this command:
"nohup /usr/lpp/ars/V8R4M0/bin/arsdoc get -h ARSDBASE -u CADMINOD -p V0T2R9Y3 -v -a -d /ars1 -g -o afp0500 -P -c -N -x "10927-95-0-402FAA-15094-15094" -G 'AFP0500' -i "WHERE LOAD_DATE > 0" 1>arsget.sys094 2>arsget.sys094 & "
This created what appear to be valid .IND, .OUT and .RES files. I used FTP to move them to a windows server, the .IND as Ascii, the other two as binary. I then tried to then use them with ARSLOAD, and got errors mapping field names as follows. I expect this a code page problem. The mis-translated filed names and proper value are at the bottom.
============================================
arsload: Processing file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: 12/28/11 15:38:20 -- Loading started, 7363386 bytes to process
Resource afp0500.3.AFP0500.DEPOSIT-V01.res matches the resource >4-116-0<
The field name ' ??|?+?+?(???' found in the index file does not match any expected fields. The field will be ignored.
The field name '+ (?' found in the index file does not match any expected fields. The field will be ignored.
The field name ' ??????' found in the index file does not match any expected fields. The field will be ignored.
The field name '^' found in the index file does not match any expected fields. The field will be ignored.
The field name ' (|?+????' found in the index file does not match any expected fields. The field will be ignored.
The field name '&|???+?^? ??' found in the index file does not match any expected fields. The field will be ignored.
The field name '??&|??^+ (?' found in the index file does not match any expected fields. The field will be ignored.
The field name '<| ?^? ??' found in the index file does not match any expected fields. The field will be ignored.
The field name '& ??^?+?' found in the index file does not match any expected fields. The field will be ignored.Unable to open the file: /ars1/afp0500.3.AFP0500.DEPOSIT-V01.out
Loaded 0 rows into the database
arsload: 12/28/11 15:38:23 Loading failed
arsload: Processing failed for file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: Processing has stopped. The remaining files will NOT be processed.
=========================================================
The field name ' ??|?+?+?(???' should be "ACCOUNT NUMBER"
The field name '+ (?' should be "NAME"
The field name ' ??????' should be "ADDRESS"
The field name '^' should be "_"
The field name ' (|?+????' should be "AMOUNT DUE"
The field name '&|???+?^? ??' should be "POSTING_DATE"
The field name '??&|??^+ (?' should be "REPORT_NAME"
The field name '<| ?^? ??' should be "LOAD_DATE"
The field name '& ??^?+?' should be "PAGE_CNT
-------------------------------------------------------
Sample from .IND file:
COMMENT: OnDemand Generic Index File Format
COMMENT: This file has been generated by the arsdoc command
COMMENT: December 27, 2011 23:00:41
COMMENT: CODEPAGE:1047
CODEPAGE:1047
COMMENT:
IGNORE_PREPROCESSING:1
COMMENT:
GROUP_FIELD_NAME:ACCOUNT NUMBER
GROUP_FIELD_VALUE:1012230201632500000901
GROUP_FIELD_NAME:NAME
GROUP_FIELD_VALUE:ROSALINA OLIVA
GROUP_FIELD_NAME:ADDRESS
GROUP_FIELD_VALUE:1632-1/2 COUNCIL ST
GROUP_FIELD_NAME:_
GROUP_FIELD_VALUE:
GROUP_FIELD_NAME:AMOUNT DUE
GROUP_FIELD_VALUE:205.00
GROUP_FIELD_NAME:POSTING_DATE
GROUP_FIELD_VALUE:04/29/11
GROUP_FIELD_NAME:REPORT_NAME
GROUP_FIELD_VALUE:DEPOSIT-V01
GROUP_FIELD_NAME:LOAD_DATE
GROUP_FIELD_VALUE:04/29/2011 22:33:13
GROUP_FIELD_NAME:PAGE_CNT
GROUP_FIELD_VALUE:1
GROUP_OFFSET:0
GROUP_LENGTH:15140
GROUP_FILENAME:/ars1/afp0500.3.AFP0500.DEPOSIT-V01.out
Try changing CODEPAGE from 1047 to 5346.
Ed
Edited .IND file. Changed CODEPAGE per suggestion, and FILENAME from omvs directory to Windows folder
Perhaps too many documents to load. For AFP, I may have to slice and dice the SQL to extract smaller numbers of bills to not exceed the processing maximum. No additional error message seem available besides the one shown.
-----------------------
arsload: Processing file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: 12/29/11 10:58:27 -- Loading started, 7363386 bytes to process
Resource afp0500.3.AFP0500.DEPOSIT-V01.res matches the resource >4-116-0<
OnDemand Load Id = >10927-116-0-414FAA-15094-15094<
An unexpected error occurred. Contact your System Administrator and/or consult the System Log. File=arsadmp.c, Line=1032
Unable to store the object >414FAA1<. Object size 19635
Loaded 486 rows into the database
arsload: 12/29/11 10:58:47 Loading failed
arsload: Processing failed for file >afp0500.3.AFP0500.DEPOSIT-V01<
arsload: 12/29/11 10:58:47 -- Unloading started
OnDemand UnLoad Successful - LoadId(10927-116-0-414FAA-15094-15094) Rows Deleted(486)
12/29/11 10:58:52 -- Unloading of data was successful
arsload: Processing has stopped. The remaining files will NOT be processed.
> consult the System Log
Nothing in there?
Seems like you should be able to load huge files, what I see doesn't look all that big. ???