DSXchange

Hi all The below query when executed in the database, i am getting the error: Incorrect syntax near 'Sun' select Distinct ProviderNumber,substring(printerexception,1,50) as PrinterException from providerpmg,AZ_locations where (PrinterException like 'Mon. - Fri.: 8:00 a.m. - 8:00 p.m.; Sat. - Sun.: 8...

Hi Tanaya

You cannot insert Duplicate records in to the table there may be Primary key/Unique Key on the columns.so use remove duplicate stage .

Hi when iam inserting the data in the table i am getting the error as shown below APT_CombinedOperatorController,0: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'Table_Name'when IDENTITY_INSERT is set to OFF. for the table we had ...

Hi Phani

u can find these stuff in Datastage PDf's or you can search in forumns or search in DSXchange

Hi all

as per my project specifications ,we should not use datasets or flat files,
and i am doing this in the same job, we dont have temporary tables also.

Src--->Tfm---> Trg(Update

)

Hi i want to update the same table my sourece & target is same(Sql Server) and i am using ODBC stage,there is no transformation Logic my SQl is UPDATE Table_Name SET Table_Name.Column1 = 'FL' WHERE Table_Name.Column1='XX' AND Table_Name.Column2='CO'; i had only 9000 records,and it is going to Ha...

Hi
I am using SQl Server 2005 as the Database.Source & Target is the Same Database.which environment variable should be used to get my requirement.

Hi
what Environment Variable should be used,and what is use of Array size?

HI i am using ODBC stage and i want to commit after every 1000 records, what Environment Variable should be used,and what is use of Array size? so if i use after commiting 1000 reocrds, and the job got Aborted,then if i start once again wheteher it will start from the starting or where it is aborted...

Hi Srinivas

Continue is like LEFT JOIN,
Drop is like INNER JOIN,
Reject- the record goes to Reject link,
Fail-we can make Lookup to fail when the condition not met and tha job grt Aborted.

HI i had multiple SQls to be executed in my job, when i use Close/Open command can i write multiple SQls , my reqiurement is i had DELETE and UPDATE SQLs that should be executed before or after,but can i write many SQLs In a single OPEN or CLOSE command. i.e., 1) UPDATE TABLE_NAME------set--------- ...

Hi i am running on 2-node processor and i made the target as HASH partitioning and the job finished successful for a particular job and again for another job, the job got aborted with following error message ODBC_Enterprise_76,1: Fatal Error: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]...

Hi i am doing Union all operation by using Sequence Funnel and i am fetching the data from 3 sources and Joining the data.and last i used the Funnel Stage i am getting the following error [ IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Duplicate key was ignored. cs}}},1: Fatal Error: Unabl...

HI all

so i need to change the Datatype by using Modify stage or is there any other option.

Hi i am running on 2-node processor and i made the target as HASH partitioning and the job finished successful for a particular job and again for another job the job got aborted with folloeing error message ODBC_Enterprise_76,1: Fatal Error: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]T...