DSXchange

What do you mean by secure? You don't want some jobs to be accessed by all or some other things?

For a transformer , definetly an output link should be there, but you can set the constraint to @FALSE, so nothing will be written to that file. If you want to store some constant values to the userstatus, you can just call it in stage subroutines, but here you are fetching some values from Database...

Welcome... In SJ1, you can read the value from the database and set the value to user status by using "DSSetUserStatus". And you can fetch the values in the Sequence job by using SJ1's jobactivity.$UserStatus. Search the forum for the keyword DSSetUserStatus, you will get more details on h...

generally for this requirement, i will write a bat file, which will export each job in a different dsx file and finnally append all the dsx files to one. For /F "tokens=1" %%i in (C:\export\DsxList.txt) do ( C:\Progra~1\Ascential\DataStage7.5\dsexport /H=AnandLocal /U=Administrator /P=****...

Kim Duke posted some scripts to search for a particular string in a project. Use that script and change only the required jobs and reschedule them.

It is not recommended to check the OMIT box, while logging in. Try logging in with the local system Userid / password.

The best way to restrict the rows is by doing a lookup.

It Seems .trap.hash is a directory pathed hashed File. For doing a select from the directory pathed hashed file, you have to SET the path in VOC.
Search the forum for the keyword SETFILE.

Just Create a file with the same name in the same path. You can do this with a routine, called in after job subroutine or a simple job which can be called after your original job completion.

Converting 5 sheets to 5 different CSV files ?

Try running this query in SQL+ or any SQL client, and see if you are able to execute it.
And if any other job is working fine using OCI stage.

If you are using OCI stage directly, instead of you have to use

Can you paste the SQL, and the value for LastModifiedDateTime.

For TO_DATE, what is the format you have given, and in what format, you are getting the Date.

If i remeber correctly, In PSFT the LastModifiedDatetime will be passed in YYYY-MM-DD HH24:MI:SS. So give the format string like this.

Check Kim Duke's Website. He is having a Batch file, which will backup all the projects in a server.