DSXchange

Hi All, I have csv file which contains 5 columns and there are 8 columns in oracle table. The 5 columns from the csv file as been populated and I have assigned default values to remaining columns.The error what I am getting. LoadPSBBIPY022..OraDummy2: The value of the row is: EMPLID = 12023652 ERNCD...

Hi All,
I am new to datastage. I have a csv file and I have to load it into the oracle database. Here I am getting data in a stream. And I have to sperate the columns. What Function exactly I have to use. Previously I have worked on using fmt in parallel.


Thank u
Meena

Hi Arnd,
I am new to datastage. I do not know whether I am right or wrong. Sorry, if I make a mistake. I want to know is it possible to do this by FTP or not.

Meena

Hi Somaraju, Can you give me the complete design. Because I want to know what stage are you using intially(before to the transformer), where you can write a user defined sql. And conversions of datatypes, null handling can be done in the transformer stage. Meena Hi Please help me to over come this p...

Hi Somaraju, I am new to datastage. But I can give you a idea how to do it, well lets try it. It may work. I want to know what are the stages you are using in the DS job design. If you are using a Oracle stage in your design then you can use "sequencename(columnname).NextVal" and assign 71...

Hi Ujjwal, Roy is correct, You can use sed command in the DS job. Nor you can write a contraint, saying that the "output stream is not equal to NULL" if you have used a transformer in your DS job. Meena In some cases when we use FTP to read files, we get a NULL record at the end and hence ...

Hi All,
I got the required output.

Thanks a lot
Meena

Hi I wrote a stage variable to handle the null values by using IsNull and NulltoValue functions. Right now my rows are not getting rejected, the total number of rows are imported into the sequential file. And I got new problem in this job. Before I ask the question, I like to explain my job and what...

Hi I wrote a stage variable to handle the null values by using IsNull and NulltoValue functions. Right now my rows are not getting rejected, the total number of rows are imported into the sequential file. And I got new problem in this job. Before I ask the question, I like to explain my job and what...

Hi , I have few rows going to sequential file from the transformer stage in a job. In all rows 20 rows are getting rejected at the sequential file. I do not want to rejected those 20 rows were I want to see them with the remaining rows. Is there any way I can we all rows without rejections. Thank Yo...

Hi,
The function worked for me.

Thank you
Meena

Hi
I am sorry for not posting in detail. I went through the reply to the question and checked with the metadata, actually I was trying to do it manually and now I imported it. So, My problem got sloved.

Thank You
Meena

Hi All, I want to know how can we add number of months to today's date in the transformer. something like " DATE() + 12 MONTHS". As I know I can add in sql by using a sql meta tag : %dateadd( date,-no of days). But I want to do it in the transformer by writing a simple stage variable expre...

Thanks a lot ArndW.

Meena

Hi I am new to datastage. I am working on a job where I have to put data into sequential file and use that sequential file as an input to other stage,were I have make a camparision. I got the results in the 1st job (in sequential file). While I am using the same sequential file as an input in the ot...