DSXchange

How about this? BCI at work. FUNCTION MaxJobNo(IgnoreMe) * Build SQL query to get max job number. Query = "SELECT MAX(CAST (JOBNO AS INTEGER)) FROM DS_JOBS " Query := "WHERE NAME NOT LIKE '\\%';" * Bind Ans to the single result set column. ErrCode = SQLBin...

The Trim() should also be unnecessary; a "MCN" conversion takes out ALL non-numeric characters, including line feeds, field marks, and so on.

You don't need any functions in the routine. DataStage BASIC permits "substring assignment" with which you can replace a substring simply by having the substring on the left hand side of an assignment statement. FUNCTION ReplaceChar(TheString, ThePosition, ReplacementChar) Ans = TheString An...

Can i ask you one thing how can i get 10/Jan/2007 not JAN i need (Jan) Oconv(Date(), "D2L") or Oconv(Date(), "D/DMYL[2,A3,4]") The "L" character preserves the lower case. Or, less efficiently Oconv(Date(), "D2/" : @VM : "...

You're missing one very important point. Because it's a UV query, ReturnCode will be set to the (positive) number of rows returned (which will be 1 in this case). An error will cause ReturnCode to be set to a negative value. Therefore the original routine was satisfactory except for the "<> 0" logic...

There is one example job, if I recall correctly. At least in version 7.5x2.

I do have a server IsValid() function. However, I'm not at a DataStage site this week, so won't be able to post it until I am (need a DataStage client to get at it). I will update this thread once I've done that.

Just a thought - what if you execute a Bourne shell script from DataStage and that Bourne shell script invokes your Korn shell script? Does that fail in the same way? Yeah, you shouldn't NEED to, but it might prove to be a workaround. You could even pass the pathname of the Korn shell script as a co...

Probably the latter, since Citrix is establishing a slave session running a DataStage client, and it's on that client machine that the permissions are required.

RSS is RUSSIA with the vowels removed.

DataStage 8.0 does not have that. What is does have is a new object called a "parameter set" - literally a named collection of parameter definitions, so you can load that instead of the individual parameters. Makes life a lot easier! You can also select from the list of parameters in the set to effe...

dsjob is also in the Parallel Job Advanced Developer's Guide though the material is identical to that in the Server Job Developer's Guide because dsjob is used in exactly the same way irrespective of job type.

My DataStage training materials are, however, "proper" training materials including hands-on labs.

You can also source training materials from IBM but they will insist on providing an instructor as well. (That is also my preference.)

Seems like a lot of work to reproduce a special case of the UNIX tr command, Brad!

DataStage does not provide inherently for aliases in mainframe jobs. However, if you specify a valid alias in the SQL, that will be passed to DB2/390 and honoured.