DSXchange

Hi All, When i am trying to load from Staging Database to Work Database the below error is coming. Odbc Connector--->Tranformer Stage--->Odbc Connector It's a plain one to one mapping, it consists of 6 char columns and 4 date columns. Error: ODBC function "SQLExecute" reported: SQLSTATE = ...

Hi Ray Thanks for the reply. I have issue in Sorting i am using only date (desc) now i added 2 columns id(asc) as well and issue is sorted.

The value for APT_STRING_PADCHAR is 0x0..

Thanks for the reply.

I have used TrimLeading and Trailing spaces and i changed the datatype to Varchar2 also and tried, But not working..

Is there anything which i am missing

Hi All, I have a job design and scenario below. Oracle Reference | Sort Stage | Transformer | | oracle Source-->Transformer--->Lookup---> Tranformer---> Oracle Target | | Oracle(Reject) 1) Oracle Source(Query joining with 5 tables) contains Title_Ids(lookup column)-- char2(70 char) 2) Oracle Referen...

Chullet.. The information on the left-hand pane shows Premium member expired. For this I have to give you some information that I have registered it in 2007 and in 2009 i have registered for 1 year for Premium member and it has expired in May 2010, as i have again made payment for Premium membership...

No it is still not activated Chullet..

I have made a payment for 2 years to dsxchange (On Demand Strategics Inc) but my profile is not activated with Premium Membership from 3 days. Can I know when will it get activated?

I have one ADDR_TYP_CD column with length of 10 i.e char(10) if iam getting more than 10 characters then the job should abort and if iam getting less than or equal to 10 characters I should read those data. I know Varchar(10) can achieve only 2nd requirement but i have to do both. Can anybody help m...

Yes Kryt0n It has spaces but with Varchar field.

Iam doing SCD type 2. My Job design is as follows:- oracleconnStg oracleconnStg RefLnk RefLnk oracle->LKP ->CDC --->TRF --->OracleConn_Ins,OracleConn_Upd From Source I have one column PHN_NBR which haven't got Nulls but while inserting into the target table Iam finding some records have Nulls into t...

Can I know how to do this?

Compiling: Source = 'RT_BP638/JOB.616080811.DT.1602916601', Object = 'RT_BP638.O/JOB.616080811.DT.1602916601' *****************************************************************************?* 0249 $DEFINE JobParam%%105 STAGECOM.JOB.STATUS<7,115> ^ Variable Name (LOCAL) unexpected, Was expecting: Assig...

ray.wurlod wrote:Presumably there's no table called lnk in the DB2 schema.

lnk.act is the field name.
Kindly help me to resolve this issue.



Regards,
Sudheer

Am reading data from db2 database using odbc connector and writing to oracle connector in datastage 8.5v, after doing some aggregations again am updating the values in odbc. while updating am getting below error "ODBC function "SQLExecute" reported: SQLSTATE = 42S22: Native Error Code...