DSXchange

When i was running a job, i got an error. After making chages and running job again for 5 or 6 times, no error found. But the log which showed the error is gone. I would like to look into that error. Can i retrieve the error in any way

unix command activity----->job1 In unix command i was doing cat of a file. its output is 0003.200808. i was trying to set one of the parameters of job1 with this value. So in the sequece i have job1 parameter as unix command activity.$command output. Now the error is Inappropriate value for paramete...

I suspect that the problem is more likely related to the "#" character in your invocation ID. Can you try it with a different invocation ID, one that does not have a "#" character? I tried with other invocatio ID . But still the problem persists. Can i use a server routine in pa...

call DSSetUserStatus(Arg1) Ans=Arg1 This is the code i have written to set user status. I am calling this as a function in transformer and passing the value to a sequentila file. But i will use this UserStatus Output in the next job using parameter jobname.userstatus parameter. But when i eecuted th...

No. You'll need to have the value before the job starts and pass it in as a Job Parameter to use it in the filename. How can i pass a transformer field value to the subroutine SetUserStatus. We cannot view the transformer field value (this is dynamic, changes for every job) in the after job subrout...

No. You'll need to have the value before the job starts and pass it in as a Job Parameter to use it in the filename. How can i pass a transformer field value to the subroutine SetUserStatus. We cannot view the transformer field value (this is dynamic, changes for every job) in the after job subrout...

No, not in the same job. However, what you can do is run a separate job where you get the filename and then set the user status using Basic routine(setuserstatus) from within the job and pass out the filename to a sequence which can then call your actual job and pass the filename as a parameter. Al...

Cant we use all the coditions in filter stage as we use in Where clause of Oracle query. When i try to use the Upper(xxx), Parse error. Does it work only for like and between. does it work for =, AND, OR etc

i have a job where Oralce statge, its output is fed to output of Transformer and its output is fed to Sequential file. lets say transformer has a field and its derviation field is pulled direclty from its input i .e the derivation field will a column value (direct pull from oracle stage). Now i have...

Can i pass the run time values to parameters and use that parameter at other place. Say i wish to pass a columns derivartion output of transformer to parameter and again use the same parameter in next stage.

chulett wrote:

just4u_sharath wrote:To my understanding trim can only wipe away spaces.

Not true.

Define 'special'.

i looked for this in transformer (Define special). but i didnt find it. Please let me know where can i use this and its implementation

How can i trim the special characters if i get them in my data. To my understanding trim can only wipe away spaces. Do we have any functions to trim the special characters in Parallel extender. Please let me know.

Line terminators in the command output are converted to field marks and the entire result is presented as a single string. It does not matter whether the operating system is UNIX or Windows; this technique is consistent across platforms and thereby allows for portability. A field mark can be access...

Line terminators in the command output are converted to field marks and the entire result is presented as a single string. It does not matter whether the operating system is UNIX or Windows; this technique is consistent across platforms and thereby allows for portability. A field mark can be access...

I have a scenario where i am extracting data from Oracle database and manking tranformations on that data. So my first stage will be oracle enterprise stage to pull data and from there the job flows. My concern here is if i put the nullable filed of a column to 'NO' in the stage and i got a record w...