DSXchange

DataStage runs by running dssh or osh as its shell. To be able to have access to shell variables they would need to be exported from the shell from which dssh/osh is invoked; therefore they need to be environment variables.

It helps if you think of DataStage from the perspective of the database server as "just another client application". Therefore, what you require on the DataStage server machine is exactly the database client software that you would need for any other client application.

Every input link you draw to a Transformer stage after the first is a reference input link; it will be drawn with a dashed line. A reference link requires you to provide a Key Expression in the Transformer stage; the value generated by this expression is sent to the stage on the other end of the ref...

34 is the double quote character. Perhaps your data in the AI_City field contains an extra double quote character. Or lacks one. Check your data.

It's preferable to use parallel functions rather than server routines in parallel jobs. Your transformation can be readily achieved using DateToString() nested inside StringToDate() if the source and target data types are date or the reverse nesting if the data types are string. BASIC Transformer st...

This tab can not be enabled for parallel job (other than for the warnings limit). The only way to limit the rows is to compile in trace mode. This is accomplished by opening the job properties window and selecting the Execution tab. It's intuitive from there - if not, click Help once there to get ad...

Isn't it "%nn" for the minutes component? And isn't it the case that you don't need the format string if your timestamp is in the default format?

Welcome aboard. Lookup stage only pertains in parallel jobs. In server jobs you use a Transformer stage to perform lookups.

Netiquette Note Do not "shout" (use all upper case). It is considered rude. Open Director. Sort by job name, by clicking the column heading in the grid. Under the View menu disable Show Categories. Wait till Director refreshes when it will show you all your jobs. Find the job name in question and r...

Please be patient. It's the wee small hours of Monday morning at DSXchange - look at the time on the home page when you're logged out.

Alas, only they can help you.

Yesterday and today I have had a 100% "success" rate with posting.php timing out.

Can someone please take a look at this? It really does detract from the site.

Enrol as a premium member.

Premium membership is one of the ways that this site is funded. I am neither inclined nor prepared to prejudice that; I find this site too useful to allow it to die through lack of funding. To make even one exception would create an unacceptable precedent.

Procedural Note We don't do "urgent" here and that goes double for Sundays. If you want "urgent" sign up with your support provider and learn the true cost of "urgent". DSXchange is an all-volunteer site whose participants post as and when they can. Premium Membership Premium membership costs less ...

Setup an ODBC System DSN (not a User DSN) uing the ODBC driver for Excel. Select the Workbook that you want to access. This step has nothing whatsoever to do with DataStage - it is performed with the Windows ODBC Administrator. In DataStage import the table definition for each worksheet that you wis...