DSXchange

Thanks sriven786....it works now. I will mark this post resolved.

Sorry chulett for the delay...
not sure how to tell if it's a DOS file or not. We create the file using datastage on a unix server...is that considered DOS

We are sending the sequential file as an attachment. File looks great until we try to use DataStage and send the file as an attachment...it is then that the data appears off...seems to be wherever a row contains a }

any help is greatly appreciated.

We are sending a sequential txt file as an attachment.

We are trying to use the Datastage email activity stage to send an attachment. The data looks fine if we email the attachment ourselves outside of datastage...however if we ask datastage to send the attachment it changes the record format when it encounters a } all records that do not have a } are f...

Hi I gave it a shot, the DS sequencer still aborts. Looks like DS still knows somehow that the command could not find the file. Any other ideas are greatly appreciated. rtneCreateList (ROUTINE DSU.ExecSH) started 13:05:33: rtneCreateList finished, reply=1 13:05:33: Exception raised: @rtneCreateList,...

I have tried this "ls -1u /blah/blah/blah/FILENAME*.txt > /blah/blah/blah/FILENAME2.txt > /dev/null" and "ls -1u /blah/blah/blah/FILENAME*.txt > /blah/blah/blah/FILENAME2.txt > 2 /dev/null" but still get the error /blah/blah/blah/FILENAME*.txt not found do I need to change where/...

Hi, thanks for reading. I have a datastage job with a routine activity step. In the routine activity I use the following "ls -1u /blah/blah/blah/FILENAME*.txt > /blah/blah/blah/FILENAME2.txt" If FILENAME*.txt isn't found I get the 'no such file or directory error'. It is very common to not...

I have already read the DS documentation and did my own google research, it certainly gives you an idea on what's happening at a high level, but was wanting to dive deeper. I'll keep looking and report back to this post If I find anything worth reporting. Thanks chulett and asorrell for your response.

Hi, thanks for reading. anyone know what happening behind the scenes when data is passed by value vs passed by reference? In my case I'm using a LongNVarChar field in a db2 connector that can be passed by value or by reference. I'm not sure what's going to happen under the covers. Any help is greatl...

Thanks for your help so far.

Any idea how I can change the global variable value using -envset. Can I do this in a transformer or within a datastage job?

Hi, thanks for reading.

How can I create a dynamic global variable. I want all jobs in the project to see the variable but want the ability to change the variable on the fly via a job...and all jobs would see that value.

Question answered

Thanks chulett

Hi, thanks for reading. I have a DS PX job that is designed to delete data based on keys I provide. The table is a db2 table. My commit count is set to 25000. If my job aborts and I have processed 30000 rows...will all 30000 rows get rolled back or just the 10000 that wasn't commited yet? Trying to ...

Thank you kduke, ray.wurlod and chulett for your replies. I'll give your thoughts a try. Thanks again.