DSXchange

Hi, I have two files X and Y and my requirement is to join them and I want two outputs from the join. One will have all the rows from file X. The other will have rows from file Y which did not get a hit with X. As of now I am doing a join and then passing them to a transformer and then trying to get...

Please check whether the folder /data is created or not?? Hi, I'm facing a problem during the compilation of a job. The job fails to compile and when clicking on 'Show More' , the error displayed is ##I TFSC 000001 03:14:03(007) <main_program> APT configuration file: /opt/IBM/Ascential/DataStage/Con...

HI, I have NDMed a Mainframe file to UNIX in BINARY MODE.Then I used the same as input for DS sequential file.There are packed decimal and Signed numeric fields in the file.I used the COBOL FD to load the column definition. I just used a sort stage after this and again wrote the output to a SEQUENTI...

Hi, I have NDMed a Mainframe file to UNIX in BINARY mode and using the same as input to sequential file. This file contains both SIGNED NUMERIC and PACKED DECIMAL fields. I have loaded the COBOL FD for the input SEQUENTIAL stage. In the FORMAT option of the file.. I have mentioned. DECIMAL: ALLOW ZE...

Hi, I have DS job which does a LEFT OUTER JOIN b/w 2 sequential files. This job reads the files NDMed to UNIX in Binary mode and does a sort of both files on KEYS and does a join.The job went fine and it showed the output file(SEQUENTIAL STAGE) count as same as the left input file which should happe...

DSguru2B wrote:Yes. But why are you worried about the view data part. Does your job function properly? ...

Yeah job has successfully completed.It didn't throw any errors.
SInce you are saying there is a limit , then is there any option to increase the same.

DSguru2B wrote:The error message tells you all. You have reached a limit. What happens when you run the job?

Is this beacuse my Sequential file stage has lot of columns(3650)???
Please let me know of any limitation on this??

Please help me with the below error message.I am trying to view a file which has 3650 number of columns.

<_PEEK_IDENT_>: Error message (227138) exceeds the maximum message size (131056); dropping.
**VIEWDATA ROW LIMITER HIT**

Please let me know hoe to handle this kind of error? When validating import/export function: APT_GFIX_Decimal::validateParameters: the decimal "text" format is variable length, and no external length is specified; you should possibly specify an appropriate "width" property; exter...

Hi, I am trying read a cobol file that has been ftped in the binary mode from mainframe environment to windows. I am able to import the CFD(Cobol file definition perfectly), not at all an issue. But when reading the file , I am getting some junk values in the "view data".(CFF Stage) Can y...

Hi,
I have NDMed a Mainframe file to UNIX in ASCII mode and this file contains PACKED numeric fields.
I am using this as input to Complex Flat file in DS.My doubt here is what should be record options for such files.
Like
What should be the Byte Order,Character Set,Data Format??

Post the full detail of the error message, so that we can get all the other information that you're not telling us. ... I have a Mainframe file which is 27900 bytes in length and it contains around 3650 columns.I have NDMed that file to UNIX in ASCII mode and gave that as input to a sequential file...

kumar_s wrote:CFF stage support these datatypes. ...

So while NDM trasmitting the file from MF to UNIX can I transmit it in ASCII mode or do I need to change the mode to Binary??

Hi,
I have NDM transmitted a Mainframe file in ASCII mode to UNIX and then I used this UNIX file as input to my DS job.
The problem here is I have SIGNED numeric and PACKED decimal fields in the input file.So what is the best way in DS to handle such files.

HI,
I am trying to view a file in DS sequential file which is 27,900 bytes in length.But I am getting an error saying "MAXIMUM MESSAGE LENGTH PASSED"