DSXchange

Hi, I am using a reject link attached to Oracle Enterprise stage . But facing following issues : 1. It is rejecting records only for ORA-1400 (Inserting null into not null value ) 2.If source data has column value more than specified in database i.e ORA-Value too long for column ,job is getting abor...

Hi Ray,
Thanks for your response . Can you suggest one set of all maps to read chinese and English characters as my source has both chinese and English charcters .

Because in the forums i see many combinations of maps depending on individual's datastage environment .

Thanks

Hi, I am facing issues while loading chinese characters . I tried all the options posted in the forum as using GB2312/UTF-8/ISO8859-15 but its not working . Following is the server NLS details: Datastage Ver: Datastge 7.5.2 Server NLS : MS1252-CS Project NLS:iso-8859-15 I am getting chinese characte...

You can call the Stored Procedure in the after SQl of the target DRS Stage.

Hi, Thanks for your response , The problem that I am facing is with timezone i.e EST .As source can have date in any of the time zone fmt i.e(PST,EST,CST... etc) .. I can replace '/','-' but to replace timezone I need to extract it first .And I din't find any function in datastage to extract timezon...

Hi , I am getting data from source in a file in following format: StartDate:22-10-2009 StartDate:22/10/2009 StartDate:21102009 StartDate:Thu Jan 21 14:20:00 EST 2008 I need to convert these different date formats into one common date format i.e dd-mm-yyyy using datastage and load to target oracle da...

Well, even if you copy the file containing the log, you won't be able to exploit it or read it. It is write in Basic Universe format. What do you want to do more precisely. Martin. I got the log of the job from the unix environment using dsjob -logsum command but it gives the entire log which we ca...

Hi All, I want to know if the log we are getting in the DataStage Director for a job can be stored in a file or not.If Yes, where from we can get the file. Thanks in advance I want some more information if there is a logpath for each and every project where the log file gets stored for each run of ...

Hi All,

I want to know if the log we are getting in the DataStage Director for a job can be stored in a file or not.If Yes, where from we can get the file.

Thanks in advance

While executing a job we are able to see the performance statistics of the job. Since we are able to view the performance statistics of the job for the last run .So this information must be getting stored at some location of the server or in the client system.Can any body tell me that location and h...

Hi RK,

If you are using DRS Stage then you have a where tab in which you can write your conditions.

Thanks,
bgs_vb

if anyone has that script could share.

Thanks
bgs_vb

in my case i have almost 8 jobs both parallel & sequence combined and put in the SEQUENCER. 1st job is a sequence job which fetches file from folder stage and processes it. as i said earlier, a file is dropped in the folder by another program anytime of the day and i should 1st check if any file...

Hi Gurus, I have a case, our team has designed jobs to fetch data from a folder and put it in a staging table and from there they load it to DW. All these are available in sequence. The initial part will be a file (eg: xxxxx.D.MI5.010101120345) will be dropped by another team into our folder. we pic...

yes you are correct. Is that the correct way to do, if not how could i go ahead in doing the change.