Search found 33 matches
- Wed May 26, 2010 5:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: INVOCATION ID's
- Replies: 3
- Views: 3775
INCATION_IDS
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...
- Wed May 26, 2010 2:39 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: INVOCATION ID's
- Replies: 3
- Views: 3775
INVOCATION ID's
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...
- Thu Oct 29, 2009 7:22 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Check for database connectivity
- Replies: 1
- Views: 1400
Check for database connectivity
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
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
- Mon Mar 02, 2009 12:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File Error
- Replies: 3
- Views: 2053
- Sun Jan 14, 2007 11:12 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: How to get the fraction of seconds in the time hh:mm:ss-sss
- Replies: 12
- Views: 6962
How to get the fraction of seconds in the time hh:mm:ss-sss
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.
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.
- Tue Oct 17, 2006 1:55 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: datastage script(basic)
- Replies: 5
- Views: 3293
- Tue Oct 17, 2006 12:56 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to splite Header from the file
- Replies: 7
- Views: 2312
- Tue Oct 17, 2006 12:49 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: datastage script(basic)
- Replies: 5
- Views: 3293
datastage script(basic)
I want to extract records from a flat file using datastage script(basic).Can anyone PLease Post The Script?
- Mon Oct 16, 2006 8:53 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to splite Header from the file
- Replies: 7
- Views: 2312
How to splite Header from the file
Hi all,
i have to splite Header from the file and this Header i have to send onther file
Thanx inadance
i have to splite Header from the file and this Header i have to send onther file
Thanx inadance
- Mon Oct 16, 2006 7:41 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: How to know if job run from cammand prompt whether it was sc
- Replies: 2
- Views: 1185
How to know if job run from cammand prompt whether it was sc
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...
- Thu Oct 12, 2006 10:21 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: GENERATING ERROR CODES
- Replies: 1
- Views: 958
GENERATING ERROR CODES
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...
- Thu Oct 12, 2006 3:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CAN WE USE DECODE FUNCTION
- Replies: 7
- Views: 3404
- Thu Oct 12, 2006 3:46 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: CAN WE USE DECODE FUNCTION
- Replies: 7
- Views: 3404
CAN WE USE DECODE FUNCTION
hi
i want to know can we use decode function in datastage . are any other functions similar to decode
i want to know can we use decode function in datastage . are any other functions similar to decode
- Tue Oct 10, 2006 10:10 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date error
- Replies: 6
- Views: 2072
- Tue Oct 10, 2006 9:04 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: date error
- Replies: 6
- Views: 2072
date error
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 ...