DSXchange

You both either need to use the Sequence object or you both need to leverage the KeyMgmnt routine. You can't mix the two. We have the 'SOA Edition' of DataStage, so were able to create a web service that allowed another service to pull numbers from the same source that the ETL jobs use. Without that...

I seriously doubt it.

That's good to know, but... unfortunate.

No, you can't put that in the Key expression. That evaluates to TRUE or FALSE and what needs to go there are the key values to be used by the lookup. Something like that should be your constraint or output derivation.

Matthew, by 'libraries' do you just mean custom routines or other code of that nature? Rather than any 'lib' files literally, I mean.

Does it really matter? They get loaded as the stage is opened, and that fact (and the order) is noted in the job's log. Nothing starts processing until all of that activity completes.

What dsjob options are you using in your script? If you use "-jobstatus" you'll be able to tell the same level of detail you'd see from the Status View of the Director - Finished OK, Finished OK (see log), Aborted, etc. If you need to distinguish between different non-fatal warnings, then this appro...

Just to clarify, of course you can use an 'OR' in a Key Expression to conditionally set the value being used in the Key for the lookup. For your particular problem, you need to conditionally check the results of the two lookups, not futz with their key expressions.

Sounds like they *are* using it only with the ODBC stage. Seems like this is the error to be chasing down, not the fact that anything expired:

File not found 'IVVM.LIC'

chulett wrote:Then you need to ascertain what changed yesterday. If not the job iteself, then what in the job's environment? Obviously, something did - the hard part can be figuring out what.

Ah... so it's only advice worth putting effort into when it comes from Ray, eh?

If you are unwilling to use the Administrator client: cd `cat /.dshome` . ./dsenv dssh LOGTO <your project> ANALYZE.FILE <your hashed file> Note: this will not work for 'pathed' hashed files. Are yours account based or were they created in specific directories? Post here as you would communicate wit...

Switch to using the string math functions and see how it handles all of your examples. Check the BASIC pdf manual for SMUL which is String MULtiplication, all of the others are there as well.

Refer here:

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

another doubt i have after observing the job is : FTP stage is retrieving 23914 rows and after unzipping also i am getting 23914 rows in sequential file.after unzipping also can we have same number of rows as in zip file? What? There are no 'rows' in a zip file. You are seriously confused and makin...

And there is a 'Designer Guide' pdf available for it in your 'Docs' directory.