DSXchange

Can you please elaborate on how to go about with job2.

How can I write a SQL Query which is paremetrizeble.

Do you mean I can create a job parameter say "SQL" and put just "SQL" in the User defined SQL box of the DRS stage?

Thanks for the help.

Is there any way we can do this using routines or Buildops or any other options

Even if you use Job 2 twice in the sequencer.

Job2 will get executed only once.

So performance-wise both the options should be the same.

It's just a matter of convenience.

Hi there, Can you guys Please help me with this scenario. DRS_Stage | | | | | V Sequential_File ----->JOIN_Stage---------->Sequential_File I have ten parallel jobs which have the same setup as the one shown above. Here the input source file, the schema of the input file, the output file, the columns...

After designing the whole job. you need to follow these steps... --> Save the job. --> Compile the job. And remove compilation errors if any. --> Run the job And remove the runtime errors if any. And finally viewing the data in your target file and verifying whether you have the desired output. And ...

Are you using the "Sequencer" and "Terminator" activity stages?

What do you mean by Administrator Server??

Administrator is a client component in Datastage :D

You can use the stages in the debugging/development category of the palette.
like the rowgenerator or the peek stage.

But can you post the exact requirement so that we can help you better................

:D

Congratulations to all the guys who got certified in Datastage!!

And three cheers to DSXchange and the gurus who helped you! :D:D:D

And moreover if you have data which has more than one quote your logic wouldn't work. Say you have --> Goo"d L"ogic as the data. And if you apply your logic the result will be --> Good L Which is not the right answer and as Chulett and vivek say it's not efficient. So use of CONVERT() woul...

Please Help!

Oh I am sorry!

I thought the quotes were just around the data, Not in between.
I should have read it clearly before posting the answer.
And as already said you can use the CONVERT() function.

The easiest way to do what you want is:

In the properties of the sequential file give the quote character as "

It will automatically ignore the quote " characters.

Hope it helps.

Hello, I am loading data in to DB2 Tables. The Source is a sorted sequential file and all my target tables are sorted except for one. Is there a way to correct this without using a sort stage ? Thanks Hazmar What do you mean by "Is there a way to correct this without using a sort stage ?"...

I want to insert values with a sequence in a table and a flat file. Please help me out. Thanks a lot. Hi Chulett, I did mention that the sequence value needs to go to two targets. But maybe I was not able to communicate it properly. And as you said I hardcoded the value of the key column and it's w...