DSXchange

ray.wurlod wrote:But writing from within the job will not affect the values that the job read when it started.

Of course, didn't mean to imply that and assumed that one process would handle setting up the new values before any subsequent processes needed them.

Don't use the convert() there in the call to the routine, use it on the result of the call in the actual parameter assignment or wherever it is being consumed. See if that helps.

:!: I'm going to lock this thread before things get out of hand as it's not hard to imagine what kind of responses this will attract. dssubhani - please try again but this time: 1. Post in the forum tied to your job type. For PX questions, use the Enterprise / PX forum, for example. 2. Be way more s...

Why "in shell scripting"? That seems like a needless complication to me, I would do something like this in a Sequence or more likely hand coded "job control" code.

You sure it's not "Project is currently locked"? Couldn't find your message anywhere in the forums but this one I've seen myself.

Short answer is "yes" but you should answer Arnd's questions so we have a better idea what is going on.

Worst case, a reboot/restart would work but you could also use the DS.TOOLS menu to release excess locks from dead connections, which is what typically causes the error.

I'm getting an error for this as SQLSTATE=23000, DBMS.CODE=2601 [DataStage][SQL Client][ODBC][Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.CREFEE' with unique index 'ix_location_1'. Not really sure what "this" is anymore or how we got to ins...

Not quite sure I follow but if your parameter set has an associated 'values file' then you can certainly write new values there 'at runtime' if desired.

You concatenate them together with the delimiter of your choice, in other words you create the delimited string to pass to the function. No change is needed in the function itself, all it ever does is take the passed in value, store it in UserStatus and then pass it back out. So rather than calling ...

You can put any number of values in $UserStatus - in a delimited string. Then your call to get any value back would just need to include the field number from the delimited string which you then parse out and return.

But the problem is you've been using the terminology wrong which confuses people and makes your actual issue harder to troubleshoot as we chase the wild gooses instead. So, now that things are a little clearer... I don't know about anyone else but I'd appreciate it if we can take a step back and get...

Still don't see how that is any kind of "legal UNIX pathname" with that equal sign in there. Is that is some magic MKS way to designate the drive letter?

Why? Because I made the silly assumption that (since we're here) the question was not simply how to create an empty file but how to create an empty file using a DataStage job. It's unclear just how "empty" they want it to be, so I was also assuming it should be empty of data but still hav...

It should, yes, hence the recommendation. Transaction Size = Commit Level.