Hi,
I have connected DB2 successfully thru macro and taking the value from sheet1 and keeping the same in query.
Now the issue is sometimes the value is less than 9 digits. so i couldnt able to run that query.
My query required 9 digits to run successfully. how can we do this? (I cant change the values in Sheet1)
Ex: Sheet1 value = 123456
SQL query should updated as = 000123456
Sheet1:
ssn = x.Sheets("Sheet1").Range("B" & i).Value
Query used:
Sql = "select sso.FUNC_DECRYPT_STR(ALPHA_PASSWORD) from SSO.SSO_USER where sso_user_id =" & ssn
rs.Open Sql, conn
Please help me to solve this.
Bookmarks