DSXchange

My job design: Using Unverse stage executing the below command to extract jobnames, categories existing in the project. "SELECT NAME, CATEGORY FROM DS_JOBS ORDER BY CATEGORY; After extracting the all the job names in the project pass to below basic routine to extract the end time stamp. $INCLUD...

HI How to get all the INVOCATION ID's for a Multi instance Job (Generic) in the project level. I am using below server routine to extract the Job run end time stamp. $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle=DSAttachJob(JobName,DSJ.ERRNONE) If JobHandle <> 0 Then LatestFinish = DSGetJobInfo(JobHandl...

Hi,
I want to check the Database(Oracle) connectivity i.e whether database is up or down from DataStage job level.Please advice me how i can achieve the above tasks i.e through a unix script or from any job design.

Thanks
Ravi

At one point the hashed file (note - it's not "hash" file) was not completely deleted. ... You mean to say that at that particular run the hashed file was not deleted completely before overwriting. Is this an intermittent error that i got, as the job finished successfully each time i exec...

Please tell how to get the fraction of seconds part from the date format below:
YYYY-MM-DD HH:MM:SS.SSS

.SSS indicates fraction of seconds in the above formate.

Please confirm whether there is any function or any other solution to get the fraction of seconds part (SSS) in datastage.

Thank you very much guys...

Ae go re go

I want to extract records from a flat file using datastage script(basic).Can anyone PLease Post The Script?

Hi all,

i have to splite Header from the file and this Header i have to send onther file

Thanx inadance

Hi All I'm calling a DataStage job from a command prompt, or a scripting language, as below: dsjob -server 10.242.243.15 -user 192297075 -password ****** -run DEV_ZGP0GSAS sample How will the calling program know whether it was a success or failure? Will this call return any value to the calling pro...

i have 63 columns in my source, i have to generate an error code if the source feild contain a null value then i have to check for other logics and generate errorcodes accordingly. i have created two stage variables for each column stag1 to check if the record is null or not in stag2 if stag1 is not...

i want to decode for a column like below

DECODE ( CONST_NAME
'Five', 5,
'six', 6,
'seven', 7,
'ten', )

hi

i want to know can we use decode function in datastage . are any other functions similar to decode

first and second points are different scenarios my source is sequential file and target is msoledb stage. when iam loading to flatfile it is working fine but it is coming as 2500/00/00 :00:00 when i am loading to database stage

i have a datecolumn 2055/12/09 with date datatype i have to populate to target datatype timestamp i.e to MSOLEDB but it is comming as 2055/00/00 i have tried 2055/00/00 : " " : Oconv( Time(), "MTS:" ) and 2055/00/00 :00:00:00 but it is not working 2.And i have to check a date if ...