DSXchange

You can use the DataStage variable @DATE to get the current date in internal numeric form. I don't know what format either your UDT_DATE or "sysdate" is in, so can't comment on why it isn't working. Is the "sysdate" a job parameter?

Yes, you can call it from a transform stage. You will not want to execute this for every row, though. Either in a before/after stage call or as a one time call in the initial value of a stage variable, depending upon how you get the value. The call is a function so it needs to be on the assignment s...

Unfortunately variables in jobs only exist while the job is running, i.e. they are not persistant. You can use a call to DSSetUserStatus({value}) in the job and then retrieve it in the parent sequence using DSGetJobInfo({JobHandle},DSJ.USERSTATUS)

Ascen - say again? The INDEX function will return a 0 if the 1-char len value of the variable "cp" is not found in the string otherwise it will return a value. An condition in DataStage BASIC evaluates to 0 or '' as being the equivalent of false and anything else to be TRUE.

Try doing a global replace of "cp" to "xx" in your manager to see if it really is cp and not perhaps op in your code. You could also change your line to "IF INDEX('ASQMN',cp,1) THEN Ans='' ELSE RETURN('yourtext')"

That is not a question that can be answered, it is like asking "why does my car only go 10 Km/H?". There are too many variables. If you run a job that copies from one sequential file to another in DataStage at the same time does it go at 1 row/second? or 50,000 rows/second? Does reading from your Or...

You can look up MATCH(ES) and pattern matching in the BASIC manual, page 6-382 for details.

Try


And sorry about forgetting the @FM in the DCOUNT command. C'est la vie.

The SETFILE command needs a <pathname> and a <VOC Filename> as parameters, in that order. The "mkdbfile" is a UNIX command while the SETFILE is a TCL command.

Colin, Command = 'SELECT DS_JOBS SAVING JOBNO TO 10' EXECUTE Command Capturing ScreenIO RETURNING ErrorCode READLIST AllJobNos FROM 10 ELSE AllJobNos = '' JobCount = DCOUNT(AllJobNos) FOR Index = 1 TO JobCount CurrentJobNo = JobNos<Index> NEXT Index Ans = 'Unused' Put this in a test routine ...

The default line termination for DOS files is <cr><lf>, saving it with vi might change that to the unix <lf> character only.

You can use the "dsjob -report" to get this information from your UNIX script.

Server routines can be called in parallel jobs:

a) in the job Before/After
b) from BASIC transform stages

Eric, declare that column as VARCHAR in the source and hashed file and it won't strip out the leading zeroes.

eldonp wrote:UtilityRunJob('#JobToRun#','Project=':Link1.project,0,0)

will not work, since it will not expand the value of the parameter and look for a job name starting and ending with hash marks. Specify the JobToRun with quotes and without hash marks, as per the previous post.