DSXchange

Can you please post the ECASE number, so that anyone else encountering this problem in the future can rapidly request the correct patch?

Where are you sending this result, and what is the data type of its column? Assuming SQL Server and TimeStamp, then you need to have a time portion as well as a date portion, as Cameron indicated. I do not understand how you can get 2054/00/00 out of the literal string you posted; I suspect this to ...

Or you can use a Routine activity and use DataStage BASIC functions to capture the date and time. FUNCTION TimedExecute(ScriptPath) Shell = (If System(91) Then "DOS" Else "UNIX") StartTime = TimeDate() Call DSExecute(Shell, (ScriptPath)...

Welcome aboard. :D Does your site have the PeopleSoft PACK, which includes table definitions and canned jobs for extraction from PeopleSoft databases? If so, then to extract the data ought to be straightforward. Your business analysts should have provided you with source-to-target (or, better, targe...

Sort the source file on the grouping columns, perhaps using a filter command, and then specify on the Aggregator input link that the data are so sorted.

IBM offers class DX437 - DataStage Administration that can be offered on-site or at IBM premises.

Sounds like time to involve your support provider. It works fine for me on 7.5.1 on Red Hat AS3.0.

No idea. Depends on how the names were generated. If you can, store the names somewhere (a file?) in the job that creates them, and pick them up from there in the script. Basically, you need some mechanism for transmitting the table names back to the job sequence (or generating them there in the fir...

I already answered this question in its previous incarnation so Avishek will not want me to answer it again here (seems to want to keep asking until the desired answer is obtained).

As I already said, these files are maintained from the Permissions tab in the Adminstrator client. You can edit them manually if you prefer.

It was purely an assumption on my part, but I would be very surprised if there is no utility for dumping the data into text form.

Did you use a Trim() function when populating the hashed files?

What worked?

Were the VOC entries each pointing to SDKSequences in the local project?

If so, what change(s) did you make?

Integer is four-byte integer in SQL terminology. int32 is four-byte integer in C terminology. SmallInt maps to int16 and TinyInt maps to int8. Open any table definition in the Repository and select the Layout tab; there are three option buttons there where you can view exactly the same table defini...

Create a script to drop the tables and execute this in a job sequence after the Job activity that runs the job. If there is an unconditional trigger from the Job activity to this Execute Command activity, the tables will be dropped irrespective of the status of the job (which may be inconvenient for...