DSXchange

in this case if you can stop your DS server and restart it , it will solve your issue.

singhal

Hi Buddy,

you can only make thouse column key which you are using to lookup(mapping). just make your red column to not-key column in table definition. thats all.

it will not show that coloumn in red.

Deepak

Hi Raji, we have one more way to find out all the information about DataStage job including the version no of the DS. Go to DataStage Manger and click the job you want to know the information and Click the Button Usage Analysis and open the HTML view of the recport , it will give you all the useful ...

Hello All DataStage Guru, I am using informix DB in my DS project. I want to unload the three columns from a very big table which having more than 100000000 records. Please sugest me some efficient way to unload the data from table. it can be by DS job or any scripts. one column out of thouse is pri...

Hi
I am using this code to run a job using job control ,
so i need to put DSJ.RUNRESET instead of DSJ.RUNNORMAL, m i right. but if job is already in a runable state then below code will work or not ?

ErrCode = DSRunJob(hJob17, DSJ.RUNRESET)

Hi

I am using datastage job control to call some depandent sub jobs,before run I want to reset these jobs if these jobs having status stopped and abort . can somebody help me to find out code for this .

can somebody please help me regarding this issue.

Hi Roy , I am updating existing records in a single table using three diffreent links from transformer to single informix stage. _________________________|-----A-------| infomrixstage--> Transformer |-----B--------|-----> Infrormix Stage( table) _________________________|-----C-------| I am using Tr...

Hi DSguru2B We cannot use this ODBC stage because we are using informix stage this is plugin. we have use meta plugin. i know datastage6.0 doesnot support serial8 infmromix datatype. we have tried all the option , like we took integer, numeric , typecasting , but did'nt sucessed. please provide some...

Hi All, I want to know the difference between reseting a job and clear the status file using datastage director. --if a job is in running status. we want to stop that job . should we use stop job or clear status file. what does it means to claer a status file and reseting a job . because when we res...

Hi Kris this was the same problem i have faced many times. if ur log count size is very large than the director will take more time it depands on the log size, so try to clean ur log till perticular date or Last run with out open Log View. Just click on the Job name in Status view Job--->ClearLog---...

Hi All when i run my ds job, it is throwing this warning message for some records "[Informix][Informix ODBC Driver][Informix]Could not update a row in the table." , I am updating the records in the table in informix database using user defined query in informix stage. please tell me why th...

ooh i lookked into this so any times,
but i was confused , i thought it may be some other .
ok well thx Chulett , i got ur point ,now it is very clear to me .

good bye

Singhal

Hello chulett
where can i get this option in DS version Control.
and , is thr no way to complete delete the component.

Thanks

Singhal

Hello Roy

I am not getting you , Can you plz explain it to me in simple word.


Thanks
Singhal