DSXchange

You are missing a dollar sign.

In version 7.1 and later you can select this from the "Add Job Parameter" dialog.

It might be worth mentioning that the enterprise scheduling tool currently in use is BMC Patrol, if I remember correctly.

Technically, true. Practically, I would not essay to access PeopleSoft data without the PACK.

All the jobs in the PeopleSoft PACK are server jobs.

The only way you'll get null from concatenation is if one of the operands is null. The individual expressions should not generate null if you're planning to concatenate. Generate "" or " " instead.

Well look at all the other possibilities. For example, was the hashed file loaded from Char data types that might have trailing spaces? Does the stream input have Char data type? In this particular case the fix is to Trim() both the load into the hashed file and the reference key expression in the T...

OK, g'donya for checking. I didn't. If I recall correctly, it's as I described in UniVerse. But I guess I ought to check that, too!

Unique constraint violated means that you're trying to insert a record in which there's a column value (probably the primary key) that already exists in the table. You need to find out why this is. Use the Debugger or use stage tracing to capture values from a few rows, and inspect the values. Stage...

Anything with a DS_ or RT_ or VOC... name (and the same with a further D_ prefix) in a project directory needs to be kept. The main gain is to be had from keeping too many entries from accumulating in &PH& and from the directory specified by UVTEMP in the uvconfig file. Pretty much anything ...

The PeopleSoft PACK for DataStage is typically provided by your PeopleSoft vendor, in exchange for payment. The Dynamic RDBMS stage (DRS) is part of DataStage - you have that already if you have DataStage. The PeopleSoft PACK provides a swathe of (server) jobs, routines, transforms and table definit...

My earlier post did not address your third requirement, that legal non-alphabetic characters must not be adjacent. This one is not possible using out-of-the-box functions, since you need to loop through each adjacent pair of characters. You will need to create either a parallel routine (external C++...

Welcome aboard. :D

If you want to be able to perform complete and accurate lineage analysis RCP should never be enabled.

At a guess you have a hardware problem somewhere in the disk I/O system.

&COMO& captures the output from certain commands (COMmand Output), mainly commands relating to installing, updating and checking the repository - that is, interactive commands. There tend to be few files in &COMO& and they don't affect day to day operations. &PH& is used by p...

Sorry, Whale, Int() returns "the largest integer smaller than its argument".
Int(-2.65) returns -3.

So Int() is all the OP needs.