DSXchange

The Datastage server is shared with Systest environment and Dev environment. but each environments having its own databases. there is no problem to connect the systest environment. I have faced the issue in dev environment.

I defined it in the parameter set. and invoke the parameter set in the job.

I have tried with different username/password combination still the same error persist.

kris007 wrote:Are you using the same user id to connect to database via datastage and command line. This is a simple permissions issue where you either provided a wrong user name or password or both or the password got locked.

Yes. I have used the same username and password in datastage and command line.

Sorry please find the error message below.

dbeR_Transaction_C: Error Idx = 1;
DB2Driver Embedded SQL message: SQL30082N Security processing failed with reason "24" ("USERNAME AND/OR
PASSWORD INVALID"). SQLSTATE=08001
;
sqlcode = -30082;
sqlstate = 08001

Hi,

I am not able to connect to a DB2 database from datastage.Its giving the error message like dsadm Username/Password is expired.But then when i was connectiing to the database using the same user id and password ,its working fine. Please help me on this.

please help me in getting the steps to generate surrogate keys using the user_id and the planname column.

the value for LKP_To_TFM_Check_Null.transaction_dt is

Oct 29 2008 12:00:00:000AM

Nov 3 2008 12:00:00:000AM

Hi I have used in a stage variable like If(LKP_To_TFM_Check_Null.transaction_dt = "") Then 13 else If(Len(LKP_To_TFM_Check_Null.transaction_dt)<11) Then 13 Else If(IsValid("date",StringToDate(LKP_To_TFM_Check_Null.transaction_dt[1,11],"%mmm %dd %yyyy"))) Then 0 Else 13 ...

I have used If(LKP_To_TFM_Check_Null.transaction_dt = "") Then 13 else If(Len(LKP_To_TFM_Check_Null.transaction_dt)<11) Then 13 Else If(IsValid("date",StringToDate(LKP_To_TFM_Check_Null.transaction_dt[1,11],"%mmm %dd %yyyy"))) Then 0 Else 13 in this i have get NOV 3 200...