DSXchange

ray.wurlod

A space character is not a valid value for an int8 column.

ray.wurlod

Why do you think a command would be any different from using the graphical user interface?

Actually it will, because less data is being returned.

Code: Select all

SELECT NAME FROM DS_JOBS WHERE NAME NOT LIKE '\\%' AND CATEGORY = '<<Category Name>>' ORDER BY NAME;

ray.wurlod

Nothing of the kind sajal.jain is suggesting - seems to be a locked-in parallel job mindset going on there.

ray.wurlod

Note that, in version 8, dsadm is not automatically a DataStage administrator. These rights are conferred via a suite component role in Information Server.

ray.wurlod

Did you change it in Oracle? In Maximo?

ray.wurlod

No such animal in a server job.

If your secondary reference set is ODBC-accessible, then multiple rows per lookup can be returned.

If both inputs are sequential files (or can be made sequential files) then you could perform a join in a Merge stage.

ray.wurlod

1. Disable operator combination to learn which stage is throwing the error although, in this case, you can be fairly sure it's a DB2 stage.

2. Get your DBA to check that the database was restored correctly, and that the buffer pools are sufficiently sized.

ray.wurlod

I have provided everything you need except the If..Then..Else construct.

ray.wurlod

Split each record into two records beginning with the two alphabetic characters and preserving the ID. Parse the new records so that they have the form ID, Letters, number, number, number... Funnel the two streams back together sort/merge on ID and letters. Pivot.

ray.wurlod

What do you want to do with the time component of the timestamp?

What is the data type of the target? Assuming it's a string of some kind, then one answer is

Code: Select all

Oconv(Iconv(Field(InLink.TheTimestamp, " ", 1, 1), "DYMD"), "DMDY[2,2,4]" : @VM : "MCN")

ray.wurlod

Is it always the case that there are precisely two alphabetic pairs per record?

Would you be prepared to use a BASIC Transformer stage or a server job?

ray.wurlod

Code: Select all

Left(Trim(InLink.TheTimestamp),4) Matches "4N"

will test for yyyy consisting of four numeric characters.

You can use a mix of Iconv() and Oconv() functions to change the format. Please advise your exact output format requirement.

ray.wurlod

There is no longer a Manager client in version 8.0 and later. All Manager functions are subsumed into Designer. Try some right clicks around the Repository toolbar and explore what's possible in the main menu when an object is selected in the Repository. I suspect that Move To has gone, because the ...

ray.wurlod

Yes, provided that that name can be successfully resolved to its IP address on the server (typically by gethostbyname() function).

ray.wurlod

U doesn't have the problem. The second person personal pronoun in English is spelled "you". U is one of our posters.

Search found 53125 matches