DSXchange

Did you ever come up with a solution to this problem? I have the same issue where I have two keys and if I get a match I want to move the field. Thanks Mike

Ray, thanks for your time. your suggestion to turn on the RCP for the project worked. Our default is not to have it on. After getting the process to run, I'm not getting my expected result. I used a Peek to verify how the dataset looked. I have two key fields and one field I need to combine for many...

When I go to run a job with the Conbine Records Restructure process, I get the following error message main_program: Fatal Error: Attempt to drop schema variable: "Attendee.rec"; this may be due to dropping a subrec which contains a schema variable; this operation is not currently supporte...

I'm not sure I understand your question, but if the number of fields you are checking is the same. Have the field name as a parameter also DELETE FROM #stage_table# WHERE #field_name# = '#field_value#' In the Job schedule you create you will value stage_table = table1 field_name = date_field1 field_...

Have a dummy file go thru a link or transformer and have the ODBC process have a user defined SQL where you have the parameter for the table name and a parameter for the value you are looking for. You could also have the Field_name as a parameter as well and just send it in the job sequence calling ...

Create table name and fields you want to check as parameters. Create a schedule that calls the job with proper table and parameters you need. The job will just have different parameters based on what you need to do. This assumes that you check the same number of fields wach time

I'm new to datastage but why don't you interpret the value by seeing if it is less than 1000000000000.00. Instead of looking at length look at it from a value standpoint