DSXchange

Hi ray,

the command given is giving the admin information also, whether it is possible to get only the version of the datastage alone

thanks for your suggestion

Hi all,

Would anyone please tell me how to find version of datastage at the back end using scripts .

In particular any command for finding the version in IBM Websphere Information Server 8.0

thanks in advance

Hi all, my job got aborted and the log view is given below, .Transformer_2.DSLink7: DSD.BCIGetNext call to SQLFetch failed. SQLSTATE=S1000, DBMS.CODE=1555 [DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver][Oracle]ORA-01555: snapshot too old: rollback segment number 8 with na...

Hi all, my jobs got aborted by giving this fatal error message, Sequential_File_25.FileName: ds_seqopen() - error in 'open()' - Permission denied It is in the sequence, so the sequence got aborted without executing other jobs. change made is: moved the sequential file in the unix to different folder...

Hi all, While I am trying to run the job in production I can see this message and the job got aborted without any rows transformed. DSD.BCIOpenW call to SQLPrepare failed. SQLSTATE=S1C00, DBMS.CODE=0 [DataStage][SQL Client][ODBC][DataDirect][ODBC Oracle Wire Protocol driver]Optional feature not impl...

Get your head around this idea. A date is a date is a date. Inside Oracle (or any other database, pretty much) it is stored as a binary value. Different tools have different requirements and ... my question is why its not populating the records into the target table in oracle? No lights blowing on ...

If you write custom queries you're pretty much on your own. Why aren't you using generated query? A SELECT statement can never generate UNIQUE constraint violations. I suspect you're not managi ... Hi Ray, Unique constraint violation is given when writing to the target ODBC. I need to join 7 tables...

Hi All, I am using custom query as the input to ODBC Stage and transforming to target ODBC after adding 2 more columns, one having defaulted to zero and other having sequence no. using KeyMgtGetNextValue(1).. I.FIELD2 and I.FIELD15 are the primary columns in target the custom query appears like... S...

If you want alphbetic month characters you have to specify the same. One way to do this is: Oconv(Iconv(Left(Inlink.Field1,10),'DYMD[4,2,2]'),'D-DMY[2,A3,2] ...[/quote] I tried your code, but its not populating records into Outlink.Field1. my nls_date_format is like DD-MON-RR but when viewing in TO...

Hi Can you try with the follwoing formate Oconv(Iconv(DSLink3.FieldName,"D-DMY[2,3,2]"),"D/DMY[2,2,2]") Or Oconv(Iconv(DSLink3.HIREDATE,"D DMY[2,3,2]"),"D/DMY[2,2,2]") i found my nls_session_parameters having date format DD-MON-RR, and tried for my custom que...

Substrings and concatenation will be the most efficient, and remember that there are no data types within DataStage server jobs. Right(InLink.TheString,2) : "/" : InLi ...[/quote] Hi Ray, I am using custom query in the ODBC STAGE, in that I am using TO_DATE(Field1,'YYYYMMDD') getting as I...

Which particular "it"? There have been so many in this thread! Take a step back, and write out a specification in English (with no mention of any ETL tool) what it is you want to accomplish. And le ... that is, changing the date format from 20080922 to 22/09/2008. How to obtain this conve...

Yes, but don't. If you're using ODBC you must follow the ODBC rules (YYYY-MM-DD for dates), not the Oracle rules (whatever those have been set to). ... Hi Ray, what I Understood from your response is I can develop a single job but it is not advisable, Is that right? anyhow can you make it clear how...

Thanks for your support, I had a conversation with DBA, the Oracle Default Date format is MM/DD/YYYY and when using TO_DATE() in custom sql the data is populated into target table with data type DATE. Now I had created another job for populating into target table with DATE datatype. first job ODBC--...

Can any one clarify that the functions like Iconv,Oconv,TIMESTAMP.TO.DATE will work for Varchar datatype in oracle 10g

or

it will also work for DATE datatype also in Oracle10g

Thanks in advance