DSXchange

A couple of decimal columns we have are appearing as so: 285.50. we need them to appear like this: 00000000000028550 we have put to following into the transformer stage with no luck str("0",17-len(convert(".","",DSLink3.CURNT_BAL_AMT))) For some reason this is still pro...

Does anyone have experience in running datastage on different operating systems?

We are currently running datastage in a Windows environment and we are considering running it on a unix environment. Are there any noticable benefits to switching over to a Unix environment?

message = "This is a test\n"

I had it setup like that before. I tried it again but to no avail

I'm trying to write a test email job that will read an array of email addresses from an external text file. The code is as follows. EMail = '' *** Find out what AS/400 the file will be extracted from *** OpenSeq "G:\DataStage\DStage_Data\TEST_Email_Control.txt" To INLINE Then Read: ReadSeq...

I accidentally posted that twice

Ray, I am very sorry you found that offensive. It was not my intention to offend anyone by posting the "bump," for that I am sorry. It was in no way intended on in an offensive way. I simply posted it to try and receive an answer to the question in the previous post. To answer your questio...

Ray, I am very sorry you found that offensive. It was not my intention to offend anyone by posting the "bump," for that I am sorry. It was in no way intended on in an offensive way. I simply posted it to try and receive an answer to the question in the previous post. To answer your questio...

BUMP

There is a chance that this might be a problem in the source table. I've searched for other posts of the 'CTransformerStage1: |xxx|' error. does anyone know what is in the pipes?

I'm copying this from datastage director, i'm not seeing any yellow or red messages, this will return over 1 mil rows, which is normal. It gets to towards the end of the extract, then fails

I'm receiving an error message: Extract_Daily_Balance_Status..CTransformerStage1.prod2BLINin_DAH: DSD.BCIGetNext call to SQLFetch failed. SQL statement:SELECT trim(CHPLNM), CHPFNM, CHSLNM, CHSFNM, CHADD1, CHADD2, CHCITY, CHSTAT,CHZIP1, CHZIP2, "CHACT#", CHCYCC,CHEDTE, CHESTS, CHISTS, CHCRD...

Thank you all for your posts. We resolved the problem by rebooting the server, now I'm just trying to catch up the jobs that didn't run. I will take not of these responses in case this happens again

I'm having problems connecting to datastage when I try to log on, I get the following error message: Failed to connect to host: dwetl2, project: Production ( The directory you are connecting to either is not a UV account or does not exist (39125)) I've never seen this problem before. The server wher...