DSXchange

ray.wurlod

Although it's double-handling to some extent, the following should work.

P | P | **
COPY [1] temp1
COPY [2] temp2

P | P | ** | [ temp1 = temp2 ]
RETYPE [1] 0

ray.wurlod

Are you able to share this routine? From which log are you pulling the metadata?

ray.wurlod

Or you can use CAST if your database doesn't support the syntax that elsont gave.

Code: Select all

SELECT CAST(PAY_AMT AS VARCHAR(9)) AS PAY_AMT_STRING FROM tablename;

If that has leading zeroes, space or trailing "." you can remove those with TRIM() functions in the SQL.

ray.wurlod

You can use the UNIX command basename for this particular task (getting the file name from a pathname).

ray.wurlod

OLETYPE will be INPIN or OUTPIN. The field locations vary with different stage types. You'll need to do some detective work, perhaps using the LIST.ITEM command.

ray.wurlod

Use functions MonthDayFromDate(), MonthFromDate() and YearFromDate() to extract the components, do your math, then use DateFromComponents() function to re-assemble the date.

ray.wurlod

They're stored in the relevant PIN records within DS_JOBOBJECTS.

They can also be found in RT_CONFIG and in the XMETA database.

ray.wurlod

What do the (string) dates look like in your source data? In particular, are they strictly in YYYY-MM-DD format? In any case your expressions don't guarantee a date. You need StringToDate() applied to the default values as well. And lose the trailing space on your string format string. If IsNull(lk_...

ray.wurlod

What exactly is a DB2 USB Load stage? Does it load onto a USB device?

ray.wurlod

The problem is with GEO_END_DT, not with GEO_START_DT. Transform that column similarly.

ray.wurlod

In the Transformer stage, use Field(InLink.Line, Char(26), 1, 1) and similar.

Performance tip: initialize stage variable to Char(26) and use the stage variable name as the second argument of the Field() function - that way the Char() function is evaluated only once.

ray.wurlod

I know what you're trying to do, and there's no solution in DataStage other than naming the columns from which you want to strip the zeroes.

There is a solution in the SELECT statement.

ray.wurlod

You can use a Transformer stage in a server job as a row generator. Make sure it has something to do (e.g. evaluate a stage variable), and constrain the output link with something like @OUTROWNUM <= 10000.

ray.wurlod

When you log in to DataStage, is the name of the services tier (the one with the 9080 port number) the same as the name of the engine on which the project exists?

ray.wurlod

Not within DataStage.

You could create a stored procedure that does this, and invoke that from your DataStage job.

Search found 53125 matches