DSXchange

Hi all, I am trying to select a string from a parameter set value file which holds a timestamp. This is my delta date to pull delta records. My source is SQL Server. However, when I try to compare this parameter value to the source column (USTIMESTAMP), it does not pull any records and throws this i...

Also, it seems the sole record is rejecting out of the lookup when both range and case lookup cases are implemented. I can do the SQL and it works fine, so it has to be with the stage.

Hi all, I am having trouble with a range lookup, hoping someone can shed some light on me. I have two tables, joining by a lookup. In the lookup, I need: (WHERE TABLE_A.EMPLOYEE = TABLE_B.EMPLOYEE) and (WHERE TABLE_A.ATTENDANCE_DATE > TABLE_B.EFFECT_DATE and TABLE_A.ATTENDANCE_DATE < TABLE_B.END_DAT...

qt_ky,

This has solved the problem. Such a simple solution, really. Thanks for all your help. :D

Haha I agree that it is a very easy solution. And much of it may be hidden, but the most important text is!

qt_ky, I have went to the reject link in the DB2 Connector, and to the Columns tab, but how do I turn RCP on?

Ray, Thanks for the post, but I am not a premium member.

I do not have RCP enabled. But when I output it to a dataset, it does not have any metadata defined, but the columns are there in the dataset when ran. I suppose I could always have a seperate job, having the dataset written to a flat file, however, I would need to make another 40 or so jobs, and I ...

I'm using v8.5.

I agree Brad; the metadata in the Sequential file should be grayed-out. However, it is missing.

Thanks Ray. I have tried implementing what you suggested, but in the Copy stage, there are no input columns. So I cannot drag them to the Output link to load the Sequential File. Is there a property on the reject link inside the DB2 Connector I am missing? I have also tried importing the target tabl...

Thanks for getting back to me Ray. No, I do not have any columns defined on the reject link. I cannot load a table definition, due to the 'Load' button being disabled. I have been trying to figure out a way to bring the columns down the reject link, but have been unsuccessful. I replaced the Sequent...

Hello all, I am trying to capture reject records from a DB2 Connector stage in a Sequential file. However, I just want the records in the file, not any error codes or error text. When I try to output to Sequential File, I get below fatal error: Sequential_File_34: A schema must be set in APT_FileExp...

the update installer is 8.5.0.271

Hello all, I am getting the below error message when I tried installing Fixpack 1. Has anyone ran into this before? Any help would be appreciated. Fixpack 1 installtion fails on Datastage server 8.5 due to below error "CDIIN4205E: XML Validation Failure: cvc-enumeration-valid: Value 'ISALite' i...

Yes, I created a test user and gave it access to everything and it had every role.

As for engine credentials, can you explain further and how to set them up and how do I know if they are required?