DSXchange

Use a sequence. Create a job to perform the SQL and either load the result into its user status area or write the result into a file. Once control returns to the sequence populate a user variable from the result either using the $UserStatus activity variable from the Job activity or by using an Exec...

Why "through datastage"?

Who's idea was that?

Extract the date and time portion from each timestamp, convert the days to DaysSinceFromDate() using a base date suitable in the past (maybe 1900-01-01). Subtract the dates. Add one day if the first time is less than the second time.

You can if the data are partitioned on COL2.

No. IF there are several records with the same date, then I need to pass all of them. No matter what solution you adopt, it will require two passes through the data, one to get the maximum date, the other to filter dates that match it. In SQL each nesting of SELECT statements is a pass through the d...

This one looks like you got through (there are RECV messages), but something's changed at the receiver. Is their mailbox full? You probably need to switch on more verbose tracing in the email system to resolve this one.

When you install the client, it picks up the default language from Windows and uses that. I'm sure that there is a mechanism for changing it, but it's likely that you need to change the Windows language first. Then it's probably reinstall the client.

So long as /home is defined on the currently logged drive (the same drive on which Information Server is installed) and db2inst1 is defined in there, then you should be OK.

For example, if IIS is installed on E: drive, then E:\tmp is treated as /tmp.

Execute Command activity from job sequence.

ExecDOS as before/after subroutine.

You've got MKS Toolkit (UNIX emulator) on Windows. So you can run Korn shell scripts.

Don't parameterize it. It doesn't move around.

No it doesn't.

You really should have attended the training class that I've just finished running in Singapore. All this would have been a lot clearer.

DSXchange is not supposed to be a substitute for proper training.

pandeesh wrote:Partha,
Please tell, how the source file has been encrypted.
Using which alogorithm ?
Unless that's revealed, we can't proceed for decryption.

Of course we can! The answer is "with the same software".

Hijack alert!!!

You're running on two nodes, aren't you? Think about it.

What shell script? It should also work on Windows.