DSXchange

Did you replace the text "schemaname" in the post or is that what is displayed? Cut-and-Paste your datastage SQL into the tool of your choice and see if it works or also shows an error.

Use UNIX "sed '1d' YourFileFileName > wc" to strip out the first line from the total count.

Isn't the maximum value for a counted loop of millions of iterations long enough for normal use? Start at -99999999, step 0.0001, maximum of 999999999999

Is drive "D" a local disk, or a network mapped drive?

No file size function and no line count function, but trivial to add to the program sample and even easier using the UNIX function "wc". FileSize(InputFilePath) Ans = '' ;** returned if file size couldn'b be determined OPENSEQ FilePath TO WorkFilePtr THEN LineCount = 0 ByteCount = 0 Finish...

Actually, it should be StringToDate(GLTxnread.NW_WRK_DT_SRC_ORIG,"20%yy%mm%dd") for dates in 2000 and the conversion without the century values uses the default system setttings. If you have invalid non-date values, then you should add a call to the function IsValid() to determine whether ...

Just copy your "dsjob.exe" to the remote machine and call it from there.

could you post the full error message, which (I think) will also contain the query as seen by Oracle.

No, but you could write your own in DataStage: FileEmpty(InputFilePath) Ans = '' ;** returned if file size couldn'b be determined OPENSEQ FilePath TO WorkFilePtr THEN READBLK Dummy FROM WorkFilePtr, 1 THEN 0 ELSE 1 CLOSESEQ WorkFilePtr END ELSE Ans = '' But even easier is to shell out to Unix and us...

The contents of the columns can be larger than 31 characters, but this is referring to your column name length(s) which need to be shortened.

What are the access rights to that file; since when running a scheduled job from Windows I think it uses different userid.

What happens if you add a ";" to the end of your query?

It is possible to start DataStage jobs on remote machines. Is that your question?

All of that information can be retrieved using several of the BASIC functions such as: DSAttachJob,DSDetachJob,DSGetJobInfo,DSGetStageInfo The DSGetJobInfo() function is the workhorse one which will get you most of the information you are looking for but you will have to write a bit of BASIC code ar...

Unfortunately you started a new and orphaned thread for this, just go back to the original thread and reply to that.

Moderator - please remove this orphan thread.