DSXchange

Hi Frank, Thanks, I will use FTP stage to read the file from AS400 and land it to a sequential in a separate Job. In FTP enterrpise stage, under the Source there in URI, my AS400 directory is as below: \\ibgp01/RFC7018FDR/IBSFDRCA. So I should mention the following in URI? Under connection, do I nee...

I know Craig,

They can do it for sure but they are so much no co operative....They say as the file size is big ie 30 gig so transfer can not be done...If I have to use FTP stage to get it transferred then similar issue will arise....Could you please suggest how do I proceed as they don't transfer it.

Hi All, There is one Binary file which needs to be accessed from AS400 server. I have asked to push the file to DS server but that seems to be not possible by the third party who support the application. I need the file to be landed in DS server. Can I use the z/os stage to connect to the AS400 and ...

Hi Ray,

There are comp fields and after reading it through CFF stage, I compared the data with the existing one(SAS program) and all the fields are matching...

I agree Craig. I changed it to Workaround.

Hi Craig, I wrote a script in phython to loop through the file and print length of each line and total file count. I found that each record length is variable. Hence I use a script to pad each record to make it fixed length . Then I use my copybook to read it and was successful. So I am marking this...

Hi Craig, I agree. The copybook has record length 5636 and there is no OCCURS depending clause and team said it is fixed width. In unix the file length is as below: -bash-4.2$ ls -l MONDET.D1181108.T191639 -rw-r--r-- 1 bb5g_etl edld_bb5g_etl 185854812 Nov 9 02:15 MONDET.D1181108.T191639 And record c...

Hi All, My next file is a Fixed width with Record length 5636(as per cobol copy book). I used the following settings: ByteOrder=Bigendian CharacterSet=EBCDIC dataformat=binary Record Delimeter I set blank. In the copybook there is one FIXED OCCUR clause which repeats 99 times.I flatten this array. W...

hi Ray,

If we convert all the ODO to Fixed OCCURS then it will be issue as the next available segments takes place of the previous ODO segment if it does not appear.

I have 0 knowledge in java ..No one else in the project is there to help ..So not considering this option. Waiting for IBM to respond on multiple ODO clause.

Hi Ray,

Can you kindly elaborate on this? How can I call a SAS program that reads a binary file through java stage ? Do I need any SAS license for this ? I was going through the documentation of SAS Interface library call.

Hi All, As I am having issues reading binary file with multiple ODO using CFF stage, I am thinking to leverage SAS code that reads the Binary file currently. The SAS code was to be replaced by DataStage, hence the work was started. As the SAS code is already available, can we use that SAS code throu...

Thanks Ray for the confirmation. I raised this issue with IBM local support. My cobol copy book has 5 ODO clause. Could you please suggest any alternative approach like some adjustment from source side? As ODO is there in the copybook, so the record is variable length. Can Mainframe make it fixed le...

I modified the copy book with occurs depending on clause and could see in the cobol layout of metadata tab. I imported the metadata with group column but in selection tab, I did not select the group column but used the flatten array option. In the Record option, I selected Variable length, Big endia...

Datastage documentation says, it supports OCCURS DEPENDING ON . In the example also it mentioned OCCURS DEPENDING ON..For other segments which uses, 0 TO 4 or 0 TO 6, I could see in the metadata.