DSXchange

have my Input data like ID NUM CODE 1 5 SAM1 1 5 SAM2 1 5 SAM3 1 4 SAM4 2 7 REC1 2 7 REC2 2 7 REC3 12 8 REC1 13 9 REC2 17 10 REC22 17 10 RECDDD 20 56 ACD In the output i need to display data like ID CODE 1 5| SAM1| SAM2|SAM3 1 4|SAM4 2 7|REC1|REC2|REC3 12 8|REC1 13 9|REC2 17 10|REC22|RECDD 20 56|ACD

thank you somuch for reply Aruna

hI

Thanks for the reply

Our MJC is a Basic Server Job


Thanks

Thanks for the response, We are using batch jobs.We are passing all the parameters in prm file. Job execution order in csv file to Master Job Control. If I do the bellow way, dsjob -param <JParam>=$Var I am sure it will pass the value to control job. How would it pass to actual job? Please advise me

Thank you for the updates. Let me enhance my requriement.I have a sub query,that fetches a date from one table.I am using that date in my main query.We have observed that if I have used the sub Query in my main Query, It is taking longer window to fetch records. To over come this,I have came up with...

Hi I have requirement, where I have to read a text file which contains o one date value.I have to send this date as job parameter, Later I have to use that parameter in my SQL Query. How Can I achive this? Please let me know. I appriciate your time. Note : we are not using Sequencer Jobs Thanks Vkr

Thanks for the response.

Target stage is Oracle Enterprise.
We are using upsert and the field data type is date.

Thanks
Vkr

I have insert to table in format like 'dd/mm/yyyy' No, you don't. Unfortunately, if you think you do, that means you don't really understand DATE fields or how to work with them via SQL. What is your target stage? Is the SQL generated or user-defined? Those answers will help figure out what really ...

Hi All, I have a issue with date format. We are reading from seq file and loading in oracle db. In source stage I am getting a date column as 'mm-dd-yyyy.hh.mm.ss' and it is having char data type in source side. We are loding that in to date column (date (data type)) in oracle table. Question is I h...

Hi, We have developed one parallel routine and we have executed outside datastage, It is working fine. When I try to test the same in Datastage, It is giving me Bellow error. Can you please advice me on this Issue. Transformer_1: Failed to load the library "V0S1_testsec_Transformer_1.o"; e...

Hi , NewYear Greeting to all! Well I came up with one Issue again. I have one job that unloads data from Sybase db to a dataset. When I try to run the job I am getting bellow Fatel error.But job is not aborting. All the rows were unloaded sucessfully. In my SQL I have simpel functions cast, stuff. T...

Hi Friends I came up with one Issue in my job. I am trying to run job_sequecer from autosys in QA Env . I have run the same job in Dev using direcor. It ran fine My sequencer have 6 jobs on it. After competion of 4 jobs it got aborted saying Error calling DSRunjob(jobname),code=-99 Can you please gi...

Hi, I am loading data in db2 database using datastage. In the process of loading I have two processing columns add date, Modified date. I am Using db2 stage to load data. Job design is like \ Source -----> Tfm--------> Target. Using update action : update existing or Insert New rows. we are passing ...

Can you any one give any suggestions regarding my Issue.

Thanks
VKR[/quote]

[Thanks for the advice, I am sorry for that.

Thanks
VKR