DSXchange

Hi Length precosion source1 column HOSP_NUM int 4 10 source2 column PRVDR_FAC smallint 2 5 Target column PRVDR_FAC smallint 2 5 I am using Lookup on 2 source columns (HOSP_NUM,PRVDR_FAC) and these are different types(int,smallint) and target is(PRVDR_FAC-smallint ) i am getting the error When bindin...

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...

Hi I am doing only UPDATE ONLY in upsert mode. my job will be SRC1 - - ------Lookup-----Transformer------Target(one of the source) - SRC2- my actual query is UPDATE Table_name SET Table_name.HospitalGRP = [Hosp_Grp_Num], Table_name.HospitalFAC = [Hosp_Num] from Table_name INNER JOIN Table_name2 ON (...

Hi while i am running the job i am getting the error APT_CombinedOperatorController(2),0: Fatal Error: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Transaction (Process ID 52) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the tran...

Hi
you can use modify stage before funnel and then change the data type to your requirement.

Hi

i am running the job parallel and i want to insert the records which are not in the target table(not to use dataset we have only target table),so i use Lookup and my target as a reject link and Primary output as Peek stage.so is there any option to insert the reject records from the look up.

Hi my reqiurement is to insert the records which are not in the Target(having Cluster Primary Key on Target table).i had 3 jobs and Target is same table,the first job will insert the distinct records(the job finished successful)while the Second job is aborted due to PK violation. so i need to take t...

Hi can we write multiple SQLs in a single CLOSE COMMAND my requirement is there are updates and delete on the table and the SQLs are like.... 1)update table_name set..... left join on table_name2 ..... 2)DELETE FROM TABLE_NAME LEFT JOIN TABLE_NAME2 ....WHERE..... 3)update table_name set..... inner j...

Hi while i am converting a null value to Time-stamp,the job is getting aborted with the error APT_CombinedOperatorController,0: Conversion error calling conversion routine timestamp_from_string data may have been lost and i had written the logic as If IsNull(OUT_PROVIDER_FACILITY.BEG_EFF_DATE) Then ...

Hi
can you tell me briefly what is menat by parameter marker,for the below query what are the changes i should made?
i am taking all the columns from source table and just i am writing the Delete statement,i had no idea on parameter marker.can anyone expalain on this.

Thanks
Praveen

Hi can i write the Delete SQL directly in ODBC stage my query is DELETE FROM imp_ProviderFacility FROM imp_ProviderFacility inner join ( SELECT DISTINCT mosg.StateCode, mosg.PCPGroup, pf.PRVDR_FAC, rtrim(pf.PRVDR_FAC_LONG_NAME) 'PRVDR_FAC_LONG_NAME' FROM mo_SpecialistGroups AS mosg INNER JOIN HCP.db...

Hi, I am getting an error (given below) while running all the jobs parallely, and the job is getting aborted. Fatal Error: Fatal: ORA-28547: connection to server failed, probable Oracle Net admin error my source is ORACLE and Target is SQL-SERVER there is no Transformation logic. I am using DRS for ...