DSXchange

OK, first off SQL is SQL and valid SQL will work in any tool as long as you handle the data types correctly. Conversely, some tools may let you get away with invalid SQL and what you've got there is potentially invalid depending on the datatype of your fake column "col1". What is it in you...

What exactly do you mean by "it is not invoking the web-service"? What does happen? Please post any relevant log entries.

OK. First make sure your SQL syntax is valid outside of DataStage and then you should be able to get a job to run it properly. If both SQL queries select the same number / type / order of columns, then perhaps you would find the "sql file" approach cleaner. Both sql statements could go int...

You need to add fields to your flow that hard-code your column names and then pivot them along with your data.

You'll need to rephrase your question as we don't understand what "Calling a column value of job A in job B" means. Sorry.

This seems overly complicated to me. Why not just parameterize the where clause? Select distinct CASH_CODE CANCEL_SEQ, CREATE_DATE from AP.TJMSTRINV #pWhereClause# That way if you want all records you leave the parameter blank or set it to " where CASH_CODE <> '020' " (etc) to filter the r...

Yes. A "true" result would mean the file exists and is greater than zero bytes in size. False, either it doesn't exist or it is empty.

Can't you simply avoid sending an actual NULL to any fields? For example, make sure they are explicitly set to an empty string - "" - instead? Or is there more to the problem?

Immediate Purge is always the default when you do that manually. When you select 'Auto-purge' does it show that "Enabled for this job" is checked?

Suggest you create a new Topic in the PX forum for this.

Just talked about something very much like this:

viewtopic.php?t=128627

Unfortunately, I have no idea what would cause the generation of your surrogate key to get "stuck" like that.

Go here and then look for mention of "DataStageBackup.bat" for a batch file you can run to do this. Or you can roll your own, of course, using dscmdexport.exe if you like.

Was I hallucinating or did I see some kind of "30,000" image on the home page the other day? It was kind of... ugly... but I thought that might be because we're stuck with IE6 here. And now it's as if it never existed.

So you have row buffering enabled at the project level? Not something I for one would ever recommend.