DSXchange

Hi All, I have a sql in a test file in a remote location. (on the datastage server). Can someone please suggest me if there is any way I can call this sql in ETL job and run it using oracle enterprise edition (we have Oracle as source and target) and write the output. we want to keep the sql in remo...

Thank You. The code worked.

Also there will be other data in the column, I have to match the pattern 0.0L and ignore the rest.

saADSDSADSA2.8Lhhgfhgf

desired output: 2.8L

Thanks
Pavan

yes, that is correct. There will be only 1 decimal point. The pattern will always be 0.0L.

And there will be only 1 such pattern in each record. No repetitions or duplicates in the record.

Thanks..

Hi All, I have a source file with records such as, dsadsad 3.6L dsfgfdgfdg weewqd 2.4L dsdsa vxcvbvbvbvcvccvc2.8Lfgfdgf if the data in the source file match the pattern 0.0L then I have to output the data. 0.0L pattern will occur only once per each record. desired data in the output file: 2.6L 2.4L ...

I Apologize, actualy it is other way around.. where ever there are semi-colons, I have to replace them with , (followed by single space) notes=dsadssa;sdsaddsa;dsaddfdfd;fdfdfdsfdsfds desired output: notes=dsadssa, sdsaddsa, dsaddfdfd, fdfdfdsfdsfds how can I do it using convert function Thanks

Hi All, I have a column that contains data such as notes=dsadssa, sdsaddsa, dsaddfdfd, fdfdfdsfdsfds whereever there is comma(followed by single space) I have to write a semi colon. expected output: notes=dsadssa;sdsaddsa;dsaddfdfd;fdfdfdsfdsfds can someone please let me know how can I do this datas...

ray.wurlod wrote:You've supplied a two digit year but your date format string specifies a four digit year. ...

My input data from the source is supplied with year in the
format MM-DD-YY
DATE: 07-16-11
TIME: 01:29

The desired output a timestamp with year as YYYY

Thanks..

I am on datastage version 8.1, OS AIX 5.3

Thanks..

Input data: DATE: 07-16-11 TIME: 01:29 After this code change, StringToTimestamp((Col1.DATE:' ':Col1.TIME),'%mm-%dd-%1950yy %hh:%nn') Ouput data: 2011-07-16 01:29:00 I am seeing the desired output, However I am finding lot of warning messages in the datastage log such as this, (1) Can someone please...

I have a requirement where I have 2 columns date field and time field and I have to output Timestamp field. How to achieve this? DATE:11-08-11 (DATE: 06-25-11 i.e mm-dd-yy) TIME:11:32 My thought was to concatenate them and later convert from string to timestamp, so I tried this, StringToTimestamp((c...

ORACLE_HOME=/u01/app/oracle/product/11.2.0/db; LD_LIBRARY_PATH=:/u01/app/oracle/product/11.2.0/db/lib:/u01/app/oracle/product/11.2.0/db/jdbc/lib TNS_ADMIN=/u01/app/oracle/product/11.2.0/db/network/admin PATH=$DSHOME/bin:$APT_ORCHHOME/bin:$APT_ORCHHOME/etc:$PATH:$ORACLE_HOME/bin CLASSPATH=:/u01/app/o...

I was looking at the ETL director log for the jobs that aborted. Then I found, PATH=/opt/IBM/InformationServer/Server/Projects/Project_name/wrapped:/opt/IBM/InformationServer/Server/Projects/project_name/buildop:/opt/IBM/InformationServer/Server/Projects/project_name /RT_BP207.O:/opt/IBM/Information...

Hi All, I have a job that has been aborting recently and when I verified in the datastage director I find PATH environment variable is trying to read from 2 different databases. I verified dsenv file but i could not find any anomalies. Can someone please suggest me where else I can find the PATH env...

I could not find any word resource or contention in the datastage log