DSXchange

Egg, Lettuce and Tomato? Of course DataStage can do ELT. You'd implement EL (either in DataStage or natively) then ETL with the one database being both source and target. Where ETL beats ELT hands down is where you have disparate data sources, particularly with the "frictionless connectors" that are...

Mainly because it costs more than that to buy the bandwidth. Dennis (Editor) has been paying for the last four years; his pocket deserves a break more than the posters deserve revenue. It's still effectively a non-profit site. If revenue exceeds expenditure, it will be put back into "product" - deve...

A search for "parameter file" (with "all terms" checked) returns lots of posts.

OK, it's now over 10,100. Time to lose the banner?

You only leave Christmas decorations up for 12 nights.

Put up another banner when I hit 20,000.

0x00 should correspond to "" rather than to NULL. You could always test against this explicit character. 0x00 is known in ASCII as NUL or "the null byte", which is where most of the confusion originates. This character is used in C programming to terminate a string. Clearly a string containing nothi...

A good place to get this answer is the first two Chapters of the Parallel Job Developer's Guide . SMP and MPP are different ways of getting more than one CPU - with SMP they're all in one machine, in MPP they're in separate machines (a "cluster"). It's possible to have a cluster of SMP machines, but...

The most recent warning is a complaint about your job design, and a warning that - should a null arrive from the input - your job will abort because the output column is defined as not null. You must fix the design - probably (as suggested) with an upstream Modify stage to intercept the null and rep...

You really need to show us your job design. In general it's a bad idea to have two or more writers to the same sequential file. That it works in any environment is just luck - when it goes bad it's probably a timing error. Is your test environment on a faster machine? Write the rows to separate file...

There are no DataStage documents. However, since DataStage was originally built on what is now called IBM U2 UniVerse, you can get most of what you need in the UniVerse manuals

telnet is a UNIX service, and uses port number 23

(On Windows telnet is a DataStage service, but still uses port number 23.)

So you can connect from a telnet client even if dsrpcd is not running.

Clearly that's not something we can diagnose. There's something happening in your Oracle instance that is preventing another client (your DataStage job) from doing what it wants to do. Talk with your Oracle DBA about what it might be.

Can you test GetSQLInfo against a DSN that you know is in uvodbc.config and works OK with other jobs? Let us know what happens. Does the problem job let you view data OK? That is, is it just GetSQLInfo that's causing the problem? Does the DSN exist in the uvodbc.config file? Does the DSN also exist ...

Maybe the problem does not occur with the five records you imported to your development environment, but with others. But it's more likely that the problem is with the job design logic, or with differences in how connectivity to DB2 is configured in the different environments. Are you getting any er...

Just out of curiosity, the original post specified a job type of 390.

This is not the same as parallel jobs.

Are you seeking training in mainframe jobs too? I have had a couple of enquiries for such training, but they are still in the "thinking about it" phase.