DSXchange

Yes I have used the CFF stage,used the copy book and able to read few columns but there is one occurs clause,(its a complex file with multiple redefines and occurs) from which am not able to read the file.

Thanks,
Pravat

Hi,

I am getting variable length mainframe file with occurs clause in EBCDIC format.
Could please suggest me how I can read this file in DS.

Thanks,
pravat

Hi,

I am getting variable length mainframe file with occurs clause in EBCDIC format.
Could please suggest me how I can read this file in DS.

Thanks,
pravat

Well that explains why Field() can't find field #5 at least - it's not on the same line. You need a more comprehenive way to parse these data, perhaps do the parsing in a Transfomer stage that segreg ... Are you saying I need to use xml transformer stage. Could you please tell in little more detail...

Sample file

H|sales|01082010
D|ee|tty|yuu|45rtgtg7|
xml file
D|ee|tty|yuu|45rtgtg8|
xml file
D|ee|tty|yuu|45rtgt99|
xml file
D|ee|tty|yuu|45rtgtoo4|
xml file
T|total no of records|4

Thanks
Saha

In line D there is a | delimeter after the 4th (key field) then empty space is there and the xml file is in a new line,at the end of the xml file there is | delimeter.
after this agin D with the similar format a new set of record with xml file is there.

Thanks
Saha

Thanks Craig. By using the 4th field I have to validate the set of one row of records. I have to do a lkp with reference table if this is there in ref tab then only I have to read the xml which is there in 5th field. I have tried to read the whole file as | delimeted file but I am not able to read t...

Hi, My input file is a Pipe delimeter file. H|sales|01082010 D|ee|tty|yuu|45rtgtg7| xml file T|total no of records|5 my input file format is like above. in detail reord 4th field is the key colmun and based on this I have to read the xml.as per the input file 5th field is the xml file. I have tried ...

Hi,
I m getting following error message and job is getting aborted.

main_program: Fatal Error: Caught ORCHESTRATE exception in main program: APT_Archive::BadData: From: Loading memory archive.

Can any one help me out.
Thanks
Pravat

kumar_s wrote:Create a environmental variable PWD and add the path which points to your project directory. "/etld/etl/ascential/Ascential/DataStage/Projects/MARINA".
Or you can alternatively specify '.', which is ...

I have created the environmental variable, but still getting the same error.

Hi, I am getting following error while running the job main_program: Warning: the value of the PWD environment variable (/apps/etl/dsadminscripts) does not appear to be a synonym for the current working directory (/apps/Ascential/Projects/edw). The current working directory will be used, but if your...