DSXchange

What do you get in the text file if you don't use the TO_CHAR function?

$CommandOutput is an activity variable associated with an Execute Command activity in a job sequence. It may be used to supply a value to any downstream activity, for example to a job parameter in a Job activity or to a routine argument in a Routine activity or to any trigger expression.

Then you have to resolve whatever caused the message - 0 rows out either means that the rows were rejected within the job, or that they were rejected by the database server to which you sent them. Or, perhaps, that the after-job subroutine is not well written and is not performing row counts on all ...

Are there any "funny" characters (for example "#", ,"?", etc.) in the password?

For less than 30c per day you can purchase premium membership and be able to read the entirety of premium posters' contributions, as well as to have access to additional material for example in the Learning Center. UV.ACCOUNT is a hashed file in the Administrator's account (UV). VERIFY.SQL is a com...

Version 8 is rather different, as you have observed. The big problem is that your design time metadata are also stored in the XMETA database, and there's no convenient way to restore that from your backup files. Even ignoring that, if you restore to a different location, you are going to need to eff...

DataStage server.
Designer, Director, Administrator.
When's the interview?

In a job sequence get the count. Create a counted loop in the job sequence in which the start value is 1, the increment is 1000, and the limit is the count obtained from the table. When running the job within the loop assign one job parameter with the loop index variable ($Counter) and another with ...

Catastrophe if you use rm, so don't. You need to be aware of the fundamental interconnectedness of all things in the Repository. Why not switch to Detail view in Manager which shows the date/time modified and select jobs from there for deletion? You can also get a list from DS_AUDIT. SELECT * FROM D...

Change your transaction and array sizes to 1. This sends a COMMIT every row.

Welcome aboard.

Search your file system to find where xlC_R actually is. This is where the APT_COMPILER (and probably APT_LINKER) should point.

There's no such concept as insert/update for Data Sets. Add a flag column that contains "I" or "U" in the Data Set, and use that to indicate whether the record is to be inserted and updated. Use that in the job that reads from the Data Set subsequently.

DataStage 7.5 does not require VB. However it does require .NET Framework version 1.1.

Used-defined SQL (except, perhaps, for #3) on the reference input link's database stage. SELECT columns FROM TableB WHERE keycolumn LIKE '?%'; SELECT columns FROM TableB WHERE keycolumn LIKE '%?%'; SELECT columns FROM TableB WHERE keycolumn = '?'; In all cases, provide the key value from TableA in t...

Welcome aboard.

You note that there is no longer a Manager client. Is Usage Analysis available from the Designer client menu? (I don't have access to 8.0 at the moment.)