DSXchange

No Craig,

The sequence didnot run at all.

Hi guys, I am trying to run a sequencer from command line. During the first run it showed an error status code of ERROR: Failed to open project Status code = 80011 I fixed the ds_login and when i try to run the job again it shows the following error status Status code = 0 Any way this can be resolved?

Craig, Here is an example of what i am supposed to do, source file ColA ColB May a May a May a May b May b May b I need to genereate a source_ id for the source file ( a sequential number starting with 1) and for each different values in ColB ineed to generate ColB_id which is unique for each value ...

Got you this time! Thanks a lot :D

criag! thanks for the response. But can you please elaborate a little bit on that.!

Hi guys, I need some help with the logic. I have a monthly file as an input. Based on the incoming file i need to generate a sequential number( the incoming file has a date column). The sequential number increments by 1 for every next(next month's) file. If for some reason I wanted to run the same m...

ok criag!

louwdata wrote:What is you ulimit settting in the uvconfig file

Sorry for being stupid, but how can I check that?

Hi guys, We recently migrated from 8.0.1 to 8.1. I am trying to run a job in 8.1 which ran successfully on 8.0.1. The job fails and is throwing the following error. The 8.1 operating system is AIX and the 8.0.1 os isSun Solaris "Sort_168,0: Fatal Error: Need to be able to open at least 16 files...

Thanks ARNDW!

Howdy,

I have a .dsx file on my desktop(win xp ) which is the client. DS server is on a remote unix server. Can anyone please give me an idea on how to open the file with datastage.



Thanks!
Marcus

Hi all,


Can anyone tell me how to create the target sequential file name based on the column value.

column
ABC
ABC
ABC
ABC


file name ABC.txt

All the values in the column are constant.


THanks!
Marcus Herbst

Thanks for the replies guys! I will try them and let you know about the result!




Thanks!
Marcus

Hi all, Can any one help me out with how this can be achieved using Transformer. I have the following input( Double= type) 1234.89 -1234.00 2345.67 in the output, i need to get the following (fixed length of width 12) +00001234.89 -00001234.00 +00002345.67 I am using the target type as Decimal(10,2)...

sorry guys! I was a little blind. The negatives were there but some how slipped past my eyes. Once again thanks a lot for your time.