DSXchange

Please paste formatted logic and use the Code tags to surround the logic. I have cleaned up your logic for you. Curr_Month_ini = "/dwtest/dw/data/CURR_MONTH.ini" for x=1 to 3 OpenSeq Curr_Month_ini To varFile Else Call DSLogFatal("Cannot open ":Curr_Month_ini: "- Abortin...

1. Write a job to spool the table to a file. 2a. Write Batch job to run job #1, then either issue a unix command to check the file for data (wc -l is a good choice), or use the DSGetLinkInfo API to query job #1 for the link row count to get the row count. If a non-zero value is found then either iss...

Glad you solved your problem, but I don't believe you were using the supplied function at:
http://www.dsxchange.com/viewtopic.php?t=85788

I used your date values and got an answer of 7200 seconds so I assumed your "Attn: Ken and Arnd" really meant Arnd because you weren't using my posted function.

What do you mean by validate? Check that it exists? It's populated? It's structurally correct?

The .dsx export does not matter. What matters is in the job designs themselves any system calls to DOS specific commands need porting, as well as the slash usage, "\" needs to be "/".

Look here:

http://www.dsxchange.com/viewtopic.php?t=85788

ODBC uses the ODBC driver for a particular database, DRS is a stage that tries to make it seamless for switching from one database to another. It uses the native connectivities for the chosen target database.

Please read your manuals, this is clearly documented.

Please use the Search facility. You'd have your answers in detail with various discussions on its usage.

Clear log removes informational messages about the jobs execution history. Clear status is used when a job mysteriously dies without leaving itself in a state that allows it to run again. Recompiling may not work, resetting is unavailable, etc. This is nicely documented in under the help button or t...

Please don't double post.

No. They are like apples and oranges. They're in the fruit family (both hold data) but are not even close in usage capabilities.

Search the forum for DEF FUN, which is required in Batch jobs to declare that a user written function needs to be used. You'll basically just put the line in the top of the Batch job.

Your issue is probably that the keys need the "n" to force numeric as Craig mentioned. They will left justify instead of right justify sort. "sort -k 1,1n 2,2n" would sort fields 1 and 2 numerically.

Lali, a lot of those questions call for opinions rather than facts. They also need specifics to a given environment. An NT implementation on a 2 cpu machine is different than a Unix implementation on a 24 cpu machine. Same for the challenges and such. Disaster recovery and failover depend on how muc...

Check out the DS BASIC API DSGetJobInfo, if you give it the token DSJ.ME as the job handle and request the job name, your function will know the name of the job running it.