DSXchange

Some Hash Def to get you started ... 8) DSArgumentMap ProjectName JobName ContainerName OutputFromStage LinkName RtnArgument ArgumentMap DSColumns ProjectName JobName ContainerName OutputFromStage LinkOrTblDefnName ColumnName DataElementName ColIsKey ColSqlType ColLength ColScale ColNullable ColDis...

Hi Group, I am doing a comparative study of informatica (PowerCenter 6.2.2 ) and Datastage (IBM Websphere DataStage Server Edition 7) to decide on which Tool to use for next project (Simple ETL for loading data in BO universe). Can some body help me in A)Pls Point me to some good sites for informati...

Yep ,
I found the error , after 4 hrs . what i did was just tried with 50 row , then again with 50 . untill i got the column :(.

i can also make use of the rejected flag , what i intend to do is re- direct the rejected records to seq file and make inserts for them only.

Hi Group , I am trying to load a large data to Oracle using OCI stage . while loading i get this error : MasterSnap..ORAOCI_LOAD.IDENT1: ORA-01438: value larger than specified precision allows for this column While i know that this error is due to truncation of data ( that is i am trying to insert m...

Hi Group, I have a request where as the XML out which i am generating needs to be changed for example . if there is no node i am just sending the closing tag </Name> My client wants if there is no data remove the tag altogether. How can i achive this I am using XMLWriter on DS 6 Thanks, Gaurav

Hi Ray, I am involved in a Project where i am migrating existing data Unidata to other platform. So for this my clients needs to review existing data. now for that they need info like table structure, Row count of every column of every tables. Since there are over 1500 tables and 5000-6000 column , ...

Hi Group,
can some body point me to Unidata ODBC dirvers.

i am asking as Unidata is also supported by Ascential DataStage , can i use any existing inbuild drivers from datastage ( for my VB application).

Thanks,
Gaurav

Hi All , I have to give a detailed description of my existing Table Definitions (Unidata) , The Problem is we have huge table structure ( Around 500 Tables and their subsequent structure) .Can I do that using datastage ? I tried exporting table definitions to xml . but I was not able to get a clean ...

Hi Friends. I need to apply a constraint in the transformer ex:- So the booking date should be equal to current date So this is what I did OCONV(booking.date, "D2/") = OCONV(@DATE, "D2/") Why is this not working? ( booking .date is in Julian ) , when I print both of these values ...

when i try to get status of a job is same project i use this:: hjob10 = DSAttachJob("Report", DSJ.ERRWARN) Status = DSGetJobInfo(hjob10, DSJ.JOBSTATUS) If Status = DSJS.RUNFAILED Then ErrCode = DSRunJob(hjob10, DSJ.RUNRESET) ErrCode = DSWaitForJob(hjob10) Call DSLogInfo("Job Reset: Re...

Hi All,
where can i find this DOS batch file ( ADN )that will automate the exports of all project on a server.
Please can you specify the exact Location?
Is is avaliable some where is in default datastage repository??

Hey this worked when i changed e delimited to 191and put Quote Char as 000 and it worked .........
Thanks