DSXchange

ray.wurlod

With what value do you want to substitute when the inbound value is null?

OutputTS=handle_null(InputTS, "9999-12-31 23:59:59")

ray.wurlod

Use a UniVerse or Hashed File stage in a server shared container.

ray.wurlod

Another approach is to parse the values into separate columns and use a Pivot stage.

ray.wurlod

Don't you ever bother to Search?

There is no such thing as a log file in DataStage. Now search on...

ray.wurlod

Welcome aboard.

Please post the record schema of your output link. Are you using runtime column propagation?

ray.wurlod

Conversion to and from date would do it, but it will be far more complex than your substring-based solution. You need appropriate format strings in each case. What happens when day or month needs two digits?

ray.wurlod

Job Sequence

Code: Select all

                           +-->  Job to insert hard coded row
                           |
GetFileSize  --->  Test  --+
                           |
                           +--> Job to process file contents

ray.wurlod

Is there any reason you can't use the UNIX command diff to perform the comparison? This could be invoked from an Execute Command activity in a job sequence.

ray.wurlod

Dump the score, inspect it, and answer your own question. Please post the results of your investigations here.

ray.wurlod

The file is "corrupted". Get whoever created it to use a different quote character (or none) around strings.

ray.wurlod

If your log grows to 2GB it will become corrupted and unusable. If this is likely, you need to resize that particular log table to use 64-bit internal addressing. Before it gets corrupted. This may not be a universal panacea; the log table will also get corrupted if a write to it is blocked by the f...

ray.wurlod

Iconv() is clever enough not to need format information.

Code: Select all

Iconv(Left(InLink.TheString,6),"DYMD")

ray.wurlod

My most recent post on this thread is as close to a direct solution as you're going to get with current software.

ray.wurlod

Most recent connection governs the current limit. So, for example, if you have a user connecting using a ten-user license, the limit is ten. If another user, with a five-user license, now connects, the limit is five (of which two are now taken). If a second user of the ten-user license now connects,...

ray.wurlod

If you attend the Information on Demand conference in October you can attempt three exams within the cost of the conference, and more at a discounted rate.

Search found 53125 matches