DSXchange

Hi Ray,

Would you please let us know the place for training and also the exact fee, so that others if interested could also plan to attend.

Also, what other topics can be included?

Thanks,
Kusuma

create a sequence to call this job (which has this stored prcedure). in the Sequence you can have a user variable activity, where you get the user name of the person modifying the data. and you can pass this as variable in the jobs. Hi Keshav, Thanks for the immediate reply. Since I already have an...

Hi all, I am using STP for calling a function that has two input parameters and a return code. Input parameters are SP_KEY and SP_USER_ID. SP_KEY has values coming from the input link. SP_USER_ID has to take the Oracle user as the value. I cannot assign the Oracle User to this input parameter in the...

kris_daredevil wrote:check the properties tab in the FTP stage look for column delimiter,escape charater

Hi KRIS,

Right now, my Column Delimiter is ;(semicolon) and the Escape Character is \(default). But it is not working with this. Am I doing somthing wrong?

Thanks,
Kusuma

It works if I treat the whole row as a single column and transfer the file. But if some one has an alternate/better solution, please share

Thanks,
Kusuma

Hi all, I have a sequentional file that looks like a1;b1;c1;....m1;n1;; a2;b2;c2;....m2;n2;; a3;b3;c3;....m3;n3;; . . the last field is empty I have a ftp job that ftpee's this file to another server, but the output is like a1;b1;c1;....m1;n1; a2;b2;c2;....m2;n2; a3;b3;c3;....m3;n3; . . The last sem...

I guess, I can not use Pivot Stage. Sam thanks for the vertical pivot link. Hi all, I have input data in sorted order which looks like Key Code 100 cd1 200 cd2 200 cd3 300 cd4 400 cd5 400 cd6 400 cd7.... My output should be Key Code 100 cd1 200 cd2,cd3 300 cd4 400 cd5,cd6,cd7.... In order to accompl...

Hi all, I have input data in sorted order which looks like Key Code 100 cd1 200 cd2 200 cd3 300 cd4 400 cd5 400 cd6 400 cd7.... My output should be Key Code 100 cd1 200 cd2,cd3 300 cd4 400 cd5,cd6,cd7.... In order to accomplish this logic I am using the stage variables. It is working fine but the la...

Hi Durga,

I am not sure about storing BLOB columns in Oracle using DataStage, but I know we can read BLOB columns using DataStage. While creating the DSN, in the advanced options, Enable N-Char Support. And I remember using ODBC stage. Please try this, it might help you.

kusuma

Thank you Ray,

Although it is simple, it is a brilliant one. It is working.

kusuma

Klaus and Craig, Thank you very much. We were exploring the options for splitting the file through SyncSort or DataStage which ever is faster. Can you please give me little more details about splitting the file through this substring method. kusuma We are using DataStage 6.0. Currently we are facing...

We are using DataStage 6.0. Currently we are facing problem with a particular type of Source files. These are Hierarical files in Unix. Originally they are XML files but the source system which is sending these files are converting them into Unix files with pipe delimited. I am attaching a sample fi...