DSXchange

Hi there, I am supporting a migration project using an Oracle Database. The approach being take for restartability has been to use Link Collector to push multiple links into one link - push that one link into a transform and the transform receiving one link will then split them into multiple links a...

Step 1. RTFM. DataStage Administrator's Guide page 3-7 Ray, I have no hard or softcopy manuals - I only have the help function on DS Administrator ... it gives UNIX servers only. From time to time you may need to stop or restart the DataStage server engine, for example, when you want to shut down t...

Hi,
I need to know how often should DataStage SE be bounced?
Will the bouncing release all locks?
Should locks be manually scanned and released before bouncing?

Compile failed on all jobs - DS bounce fixed problem

Ray I have the DS Essentails Course books - doesn't seem to cover this

What are the Step by step instructions for bouncing DataStage SE?

What does the following DataStage do?
Ascential/DataStage/DSEngine/bin/dsrpcd

I am attempting to compile a DataStage job - have done many compiles in this project(DEVDV8C4) before - now the compile fails with ' Error calling subroutine:DSR_JOB (Action=5): check DataStage is setup correctly in project DEVDV8C4 (Subroutines failed to complete successfully(30107))' DataStage ma...

I am attempting to compile a DataStage job
- have done many compiles in this project(DEVDV8C4) before

- now the compile fails with
' Error calling subroutine:DSR_JOB (Action=5): check DataStage is setup correctly in project DEVDV8C4
(Subroutines failed to complete successfully(30107))'

I have a source Varchar(38) field in a sequential file that I want to load to an Oracle DataBase target column (using a Bulk Loader) - the target field is a TimeStamp
How do I Convert from DD-MM-YYYY hh24:mi:ss to YYYY-MM-DD hh24 Using oConv(iConv ???? Please advise



Michael Mills

Ken script is great but I think it is hard to understand. I think this script http://www.dsxchange.com/viewtopic.php?t=93365&highlight=runjob is a little easier to understand. Hi Kim, Script working fine but I have new requirements. The shell script is to now read the DataStage Job arguments fr...

I get the following lines on UNIX ../Projects/$PROJECT/Staging Not Found DoNothing.ksh dsjob not found Before run Job_Status = dsjob -run - mode RESET -wait PolSubD3 DoNothing DoNothing.ksh dsjob not found You need to remove the line that cd's to staging - it is specific to Kim's scipt and not need...

[quote="ray.wurlod"]If you're on Windows XP, then you don't need Thanks Kim - I am on Windows XP - BUT I am running this on UNIX - as a UNIX korn shell script(.ksh) - I have your script close to working (POC must be thru a UNIX script) - re my question about cd $DSHOME . ./dsenv cd ../Proj...

Ken script is great but I think it is hard to understand. I think this script http://www.dsxchange.com/viewtopic.php?t=93365&highlight=runjob is a little easier to understand. Hi Kim, I am editing your script - and yes it is easier to understand than Kens script - thank you :-) On the bottom of...

Hi Ken,
I am running XP
RE: 'The command line interface program dsjob is well documented in its own manual under your Start menu'
I assume you mean the Windows START menu
- can U advise where on the START menu
- tried Help/ search
- no luck