DSXchange

In the CFF stage, right-mouse click on the column name and then choose the option "edit row", the rest follows from there. ... Thanks for your help. I can see lot of other options. But I didn't find any option to set a default value. Can you please give me the name of the option to set th...

Can you please advice me how to specify the default value attribute in the Complex Flat File?
Thanks
vrsraju

Hi I am getting spaces in the packed decimal field. I have to convert to either NULL or Zero when I get spaces in that field. Data Type is PIC 9(7)V9(2) COMP-3. Is there any option which would handle that conversion in CFF stage. If not, is there any other place I can do that conversion. Thanks and ...

Hi Thanks for your response. But my situation is I have to FTP a dataset from mainframes and insert into a DB2 table. For that I am using FTP plug in to read the data and write to Complex flat file. In second job I want to read that CFF file and lookup against Target table and find out inserts and u...

Thanks for the response.

Hi

I have used DataTypeEbcdicToAscii Ds Tranform functions in a server job to convert data from Mainframe to DB2 (EBCDIC to ASCII)

How can I make use the same functions in parallel job.. Is it supported in Parallel or any other functions available?

Thanks
vrsraju

I am getting the following error
ORAT_GFSTU48: Column UTL_ERROR_STRING has unsupported type.

I was trying to use Oracle Enterprise Stage

I need the column as this is one of the main column in the table but its not primary key or part of the key.

Hi I am trying to load the Oracle table using a parallel job in which one of columns data type is CLOB. Data Stage is not recognizing this data type. But I could be able to import the metadata using plug-in. The meata data is showing the data typa as Long VarChar(4000). But when I run the job, it fa...