DSXchange

Appoint a metadata steward. I've found that someone has to be in charge of keeping the repository clean, enforcing standards, etc. Your issue with table definitions is true also for functions, jobs, etc. A rigorously enforced standard that is periodically reviewed and refined is the best approach, i...

1. Are both tables same size? (number of rows, columns, data types) 2. Are you talking pure inserts, updates, or mixture? 3. What about triggers, any doing behind the scenes work? 4. What about foreign key constraints? 5. Have you divided inserts from updates and can you benchmark how long insert-on...

Consider using a DSExecute statement to "cat" or "type" a file into the screenoutput variable. It's a whole lot easier than reading a file, plus there's no pesky locks involved. UNIXcmd = "cat ":YourFilePath:"/yourfile.txt" CALL DSExecute("UNIX", UNIXcmd, ScreenOutput, ReturnCode) Now, the screen ou...

Nope, it works, and I do it all the time. As long as you don't Validate the job, the before commands always happen before the link opens for processing.

I don't understand why you can't put the concatenated filename into the output link of the seq stage with the two input files. In the transformer on that seq stage put a before-transformer command to cat the two files together. What happens is that the seq output won't start until the two inputs are...

A space is ASCII 32

Google up the methods by which you can use rsh. DataStage is not your problem, it can run any system level command or script you want. Your solution is configuring a trusted connection between two servers so that you can rsh.

Use the Windoze program rsh to run "remote shell" commands on foreign systems.

For the life of me I can't figure out how this job could possibly run. The logic dealing with transformer 1 has to process first to its full completion. Then, the logic dealing with transformer 2 gets to run. I don't see how you're able to use the shared container as a reference lookup in the manner...

If the job started 62 seconds after being asked by the job control function, then it went outside the tolerance the API has hard-coded into it. This problem usually occurs on a system so overwhelmed with tasks. You need to look at resource availability and see if that is when your problem is happeni...

The buffering is simply masking some issue with your job. You have something in your job design that is causing it to hang. Can you please sketch your design, your verbage is unclear.

Your problem is exactly what is stated, NOTHING ELSE. The error is that you ran out of space on the sequential file file system. Check the capacity of the filesystem by either doing a "df -k /yourdirectory" or a "bdf" (I don't know what flavor of unix you're on).

Technically YES, but the gains vary depending on the operations being done. Filtering out rows in one transformer may reduce the rows that flow to a subsequent transformer where the derivations are more intense. In this case, you're better off having more transformers. More tranformers allows you to...

Sequences are graphically designed process flows. Batches are manually written process flows. Both use the same underlying API. In fact, create a sequence and look at the job properties-->job control and you see the Batch code written.

OPENPATH will open an externally pathed hash file. OPENPATH fully_qualified_filename TO file_handle Else * put error in opening logic here End If you know the primary keys, construct a variable of all of the fields concatenated with an @TM character between each field. Ex: KEY=field1:@TM:field2:@TM:...