DSXchange

To find out how to do it with DataStage, enrol in the Ascential classes. DataStage Essentials is a prerequisite, but the DataStage Best Practices class is the one you really want. Visit the Ascential web site, track down these class names to view what they cover.

Padding is indeed one of the tasks of the FMT function. To pad a string on the right to a length of 15 characters, use FMT(string, "15L") This means "15 characters, data left-justified". To pad a string on the right to a length of 15 characters, and truncate the result at 15 characters (in case the ...

ODBC can automatically convert to internal date format, so that your transformations would not require the Iconv function.

To learn more about date conversions with Iconv and Oconv, go here.

VITAL difference.

If things don't abort, your controlling jobs/sequences can remain in control. Warnings can be detected and appropriate action taken.

Depending on the second argument for DSAttachJob, aborts can cause you to have to work nights or weekends resetting jobs.

OK, since you asked for it! To force a complete rerun then clear this file. To force one job to rerun then just clear its record. (Hey Ray if I leave off an apostrophe then please let me know or a comma) One good ("its" without apostrophe is correct here). It's "it's" when it's "it is" but it's "its...

I hope that the DataStage/Peoplesoft experience is better. A customized DataStage class for Peoplesoft support folks (DS324PSFT) was developed and has already been delivered in a couple of locations - I delivered the one in Sydney (Australia). I agree with Kim, though, that a forum here would be a u...

Yep, that'll do it!
It's like continuing to write the old year in dates for a couple of days into the new year, and we all do that.

That's not actually an error. :D All of the functions that the Expression Editor and parser "know" are in a file called DSParams in the project directory on the server. The bit functions (BitTest, BitAnd, BitOr, BitXor) are not in DSParams. However they are legitimate DataStage BASIC functions; your...

DSD.StageRun is the name of the subroutine executed to implement a Transformer stage. You can examine the generated source code in the RT_BPnnn directory, where nnn is the job number from DS_JOBS (search the Forum for RT_BP). You should be able to diagnose where the problem lies. The fix is going to...

PeopleSoft DataStage installation will also be including lots of "maps" (transforms and/or routines) that mimic what they used to have on Informatica, and a number of canned DataStage jobs for accessing the PeopleSoft application. These canned jobs make use of two custom plug in stages (one for DA, ...

The libraries need to be found by other processes. The directories in which the libraries live need to be recorded in the "shared library path" environment variable (LD_LIBRARY_PATH, LIBPATH or SHLIB_PATH, depending on which UNIX you're on). This variable needs to be set in the dsenv file, which is ...

The only publicly available materials are Chapters 2 and 19 and Appendix A of the Server Job Developer's Guide (version 7.x) and the DataStage Plug-In Writer's Guide . Chapter 2 of the Parallel Job Developer's Guide gives some insights into parallel processing strategies, but not really any internal...

Since Iam working on PX I used PXEngine instead of DSEngine and I gave the command bin/osh instead of bin/uvsh. Am I correct upto this point. Pls clarify? You are not correct. Locking of design time objects is performed in the DataStage engine. You should execute neither osh nor uvsh . You should e...

Assuming that you have DataStage software, the two manuals that you need to consult are the Server Job Developer's Guide (chapters on BASIC Programming and, particularly, DataStage Development Kit) and the Core Development Guide (Chapter on Job Sequences)

If it's done properly, production jobs should never abort. In particular, it is possible to design things to detect the few possible abnormal conditions (such as database server unavailable) prior to doing any serious processing, then take an alternate path that involves notifying someone that actio...