DSXchange

Thanks Ray. I have already read this in the previous threads but couldn't find the right pdf. can you please point me the place to look for?

Hi, I am having this strange issue with Datastage when I am reading a complex flat file(mainframe file) with multiple occurs depending on clause. The file is a variable block file & it has got multiple occurs depending on clause. Sample copy book. 01 Table 02 KeyFIeld PIC X(10). 02 Field1 PIC X(...

Why not be more patient? Column analysis can take a long time, particularly if there are many rows to process. I have had column analyses run for most of a weekend. Is there anything in the logs, ... Well, the story goes like this. I have started column analysis for which some ds jobs have been cre...

Hi,

I have triggered column analysis lot of times after processing some columns for few columns the jobs get stuck at "In progress" which never changes. is there a way to stop these? and is there any specific reason why this happens?

Ray - could you please elaborate this definition? and can you specify more about the "the values of all the characters in the key" ? and cant find any other place mentioned about bit rotate. could you please help me understand this more?

Finally I have managed to get some dummy data out of clients network. below are the file details. 01 XXXXX. 05 XXXXX-ID PIC X(1). 05 XXXXX-NAME PIC X(1). 05 XXXXX-XC PIC X(1). 05 XXXXX-SC OCCURS 0 TO 255 TIMES DEPENDING ON XXXXX-XC. 10 XXXXX-SC-TAMT PIC X(2). 10 XXXXX-SC-TDT PIC X(2). the file is a ...

yes, its a non-standard way of doing it where they have taken out the sign nibble and stored without any sign nibble. it doesnt work when I eleminate signed=?.

is there any other trick to handle this?

well, below is the sample data. they call it packed unsigned(there is no sign nibble thats what makes it different from COMP-3).

in the byte representation the data looks like this to store a 4 byte data field.

01357
02468

Sorry - I tried to put the data but couldnt.

thanks, I thought I was missing something as I was not able to convince myself that there are options but there isnt any underlying code or operator to do that job. have you implemeneted this?

Hi, I was looking a way to write variable block files in cobol file format(EBCDIC & fixed width). there are no options available in complex flat file stage and in sequential file there is an option when we define the record type as varying & format as VB. However is not able to write the fil...

well, I really cant get the data out of the clients network. so cant post it

Ray you know so much more than me - Thanks

I started this thread thinking there could be some NLS that could I am over looking. Seems, like there is now NLS so, I think its better to write a custom stage to read the data. can some one please guide me where to start it from?

the other scenario which I had missed is that there is an occurs depending on clause as well. the occurs depending on column is again in hex packed decimal format which complex flat file fails to read.

well, this is my understanding of the fields. when I say compressed characters I mean in general 1 character is stored in 1 byte in ascii and ebcdic. here they are storing 2 digits in 1 byte. to do that they are storing the data in the binary format so that they can save the nybble and store another...