DSXchange

Thank you!
I searched in forum but i did not get any version related information then i posted this ... I need to check out with admin about the previous settings to compare with current settings.

Thanks,

We are getting warning message in Ver 7.5 XXXHashFiles.ABC: add_to_heap() - Unable to allocate memory It started coming when we upgrade the system from 7.1 to 7.5 versions, the same job was running without above warning messages in 7.1 version. Does anyone come across the same issue using 7.5 versio...

To turn an XML file into a sequential file just import the XML definition into the Manager tool and link your XML Input to a transformer and sequential file output stage. You shouldn't need an XML transform stage. As you mentioned Yes! there are lot of transformations from source to Destinations, c...

Thanks roy! you are correct we need do the mapping before developing the code. But the requirement is now to trace back.. :-) I generated a .XML file it has the souce and target column names. Can any one help me out with sample how to use XML stage to parse the .XML input file to Sequential file. I ...

Hi, I have a requirement, where i need to find out the Source Table column names to Target column names. We are using ODBC stage to connect Oracle database, used user defined queries to join multiple tables to get the data and writing it to a sequential file. Now I have a task to get the Source tabl...

I tried writing a routine but it is not working.. here is the code.. anything wrong.. It is sending the mail if the Job aborts . Error message :- After-job routine returned error: Error variable unassigned on return from AFTER routine DSU.UnSuccessSendMail $INCLUDE DSINCLUDE JOBCONTROL.H JobHandle =...

Hi, I want to send a mail using DSSendmail after job routine when ever job "Un-successfull". There is option to select run only when job is successful. 1) what if i don't check the box, will it send mail when job fails? 2) any other routine will help me out to send notification when the pa...

Hi, I am getting following warning message when i run a job to insert data to DB2 table. DataStage Job 569 Phantom 24658 Program "JOB.1897336291.DT.1376447055.TRANS2": Line 291, Nonnumeric data when numeric required. Zero used. Job is inserting the rows properly but ending up with warning ...

Can anyone tell what are the valid DSJ.STAGESTATUS values from DSGetStageInfo routine.

Thanks,

You need to take the rightmost char to check whether it is a sign. Try using what you have learnt earlier. i used following transformation! IF Len(Trim(MYLINK.COST)) = 0 Then 0 Else IF Right(Trim(MYLINK.COST,',','A'),1) = '-' Then '-':(Trim(Trim(MYLINK.COST,',','A'),'-','A')) Else Trim(MYLINK.COST,...

Source Date(CHAR(15)) Target Data (DECIMAL (15,2)) 123,123 123123.00 (tric works) 123 123.00 (tric works) 231- (negative) 0.00 (tric doesn't work but it suppose to be 231.00- Right now with the tric all negative numbers are tranformed to 0.00.

Still think math would do the trick... If Len(Trim((MYLINK.COST)) = 0 Then 0 Else MYLINK.COST * 1 Give that a shot. :wink: Craig, still have the problem :cry: .. In my input data comes like 234- (negative) values, above tric is not working out!! and if i don't trim(MYLINK.COST,',','A')*1 then it is...

Craig, It worked out!!

Thanks!

Chowdary!
nope it is not working.. still the same problem...
-902

Hi , Craig, As I looked into the date in different file, Data is coming sometimes as spaces/blanks. Can any one help - situation is as follows I have Target DB column defined as DECIMAL(12,2) and source is Char filed with 123,345 or 2345- or blank - kind of data. I need to convert it to target db de...