DSXchange

scRetrieveAuditFields.ETL_JOBID_LIST: Incorrect dboption list; it failed on Expected value for property "user", got: ",", line 1 Expected value for property "password", got: "}", line 1. The error message is saying that there are no values for user and passwo...

When I put all the parameters in the stage, this is the error I recieve: scRetrieveAuditFields.ETL_JOBID_LIST: Incorrect dboption list; it failed on Expected value for property "user", got: ",", line 1 Expected value for property "password", got: "}", line 1. ...

I am not trying to view data in designer.

When I run the job, it aborts. And the director gives me the errors about not a valid table name, unable to logon, etc.

I might mention that these parameters are environment variables, so they have values of $PROJDEF in the parameter set.

Everyone on my team has same problem.

Hello, I am getting errors when trying to read from an Oracle Enterprise Stage. In the Output Propeties tab, I have to parameterize the table schema, the user and password, and the remote server. However, when I do paramterize these, I get errors saying it could not identify the schema, invalid logo...

Just for CUSTNUM.

This worked Mike! Thanks a mil!

Hello, I need a query in DB2 where it has to select the maximum value in a string field. I have to select two other fields, in addition to the field that needs the max function performed on it. Here is a sample test that we have tried: Select MAX(EXPIRE_DATE), CUSTNUM, ZH4IN from RTL.STG_MEDICAL_TAB...

Sample value: 20100808

Derivation: StringToTimestamp((lnk_GL_BALANCES_MED.POSTING_DATE:'000000'),"%yyyy%mm%dd%hh%nn%ss")

This was the solution we found. We had to pad the hours, minutes, and seconds.

Hello,

I am trying to convert a field that is varchar (8) to a timestamp (26,6).

I have tried the StringtoTimestamp function, which did not work. I have also tried PadString, but it was unsuccessful.

Does anyone have any suggestions?

Thanks in advance.

Thanks anbu. It worked.

Ok, apparently there was never a padded zero. The field comes in as 2010, numeric. But when I straight pass it to the varchar target, the last zero is dropped, resulting in 201.

datatype: varchar
size: 4

I forgot to mention that in that field, I have padded that numeric value with a zero at the end of it (i.e. 2010). So when I straight pass it, that zero gets dropped.