DSXchange

Hi, We have a requirement to split the records based on the Category Code and load to MQ. The Category Code can be dynamic and we have around 20+ category codes so I don't want to use transformer or filter to split the records based on Category Code. Is there any way other way of doing this? The opt...

Hi, We have a requirement to load set of records (Specific category code) as a single message into MQ. Can someone help me how to implement this? I know there is a option in XML transformer to do this and taking the key column whenever the value changes it will create a new XML message,so I am not s...

I have to create output in PDF format. Is it possible, if yes how can i achieve it. Currently i have the output as delimited text file but i have a requirement to have the same in PDF.

Any help highly appreciated.

Thanking in advance

thanx for the reply. There is no header file that i am aware of. I have been given this cobol definition file that i was trying to import in DS. As mentioned before this cobol definition is created by executing oracle DDL statements. There are around 50 tables. 4 Tables with datatype BLOB and LONG a...

when i try importing cobol copy book, DS throws error for PIC BLOB and PIC LONG and states invalid string datatype. I understand these datatypes are not supported by DS. I just wanted to check if someone has faced issue with such kind of datatype . If yes please let me know how i can resolve this is...

Hello, I am trying to create QETXT.ini file for Information Analyzer using DS jobs. I have to read the file definitation and pull out column name and length and have to put those in QETXT. I just wanted to know if there are any built in routine or function that reads File definition and return colum...

Is there any report in IA wherein i will have distinct value, frequency count, frequency % , datatype , length in one report I know i will get distinct value, frequency count, frequency % in most Frequent Value report and Datatype and Length in column summary report but i was not able to find one re...

Thank you ArndW, my internet was not wrking , so was not able to browse the forum

Thanks Craig, i will do that. Thanks Arnd for your reply. My output is declared as date. Also how can i demote the warning message to informational. In my job using CFF i have imported cobol def. CFF in turn has done the implicit conversion of col (PIC S9(8) COMP-3) decimal to date and i have mapped...

Not sure , instead of no 8, why it is showing one of the emotions,

Defination for the column is PIC S9("8)" COMP-3

Sorry, Def for the column is PIC S9(8) COMP-3

Defination for the column is PIC S9(8) COMP-3

I have created a job to read ebcdic binary file and convert it to ascii unpacked file. My design of the job as follows CFF --> Transformer --> Sequential file stage CFF is reading ebcdic file and is converting it to ascii unpacked file. Job is running fine , but i am getting the following warning me...

Hi, Just want to know is there a way to create column name with spaces where the output file is in tab delimited format i.e. Instead of EMP_NO they want EMP No as the column name in the output file. As we know in datastage it will not allow us to define the metadata like this..is there an alternate ...

Thanks for all your help and inputs on this.