DSXchange

Could someone please provide an example on how I might setup the userstatus variable and populate it. I have researched the guide and forum to no avail.

Thanks in advance.

P.s. I will be using the variable further on in a job sequence.

Using the Job Sequencer, I am going to create a job that populates either a variable or record with the last DB2 value. The subsequent job will have a parm that contains the value from the previous job.

In order to pass variables, how would I go about it.

Thanks

I have a DB2 file that I will append records to. The key is incrementally increased by +1 for every record written. I don't know what the last key value is when I start adding. My plan was to do a count on the DB2 table, retrieve the last key value and pass it on to the transformer stage incrementin...

Lookup values are:

FieldA = Code_Table.FieldB

If match

move Code_Table.Desc to Target.FieldA

What I am trying to accomplish is Source FieldA contains IBQ and I want to change it to the code table value in the target field

I.e. Source FieldA = IBQ change it to the code table desc value

Has anyone ever experienced a lookup that matches the criteria and the values do NOT get changed. For some reason the source is carried to the target. I used a reject on the lookup stage but it never get triggered. I assume the match is working. Is there an easier way to debug this. I have Peek stag...

Is it possible to search on multiple keys within one lookup stage. I use the same code table for two different fields from the same source

i.e. field1 = code.fieldA or
field2 = code.fieldA

Thanks

Is there a way to combine the following command in the specification line of the modify stage. CD = string_trim[" ",end](substring[3,6](CD)) I get an error. The CD column is a VarChar type. I need to trim the spaces for the lookup stage. Even though I use substring, I must suppress the rem...

Question: Can you not use to different field names to make the lookup.

i.e. SYS_APLC_NM = Table.CD


The SYS_APLC_NM will match the Table Code

I set the environment variable to TRUE but I am not sure how to dump the schemas. Could you please let me know. thanks

It is a VarChar datatype

I am getting the following error and I am not sure why: Look_Code: Error when checking operator: Key field "SYS_APLC_NM" not found in input schema I joined two DB2 tables and then used the modify stage to remove spaces from the SYS_APLC_NM field. I can't understand why the lookup stage can...

In the Specification clause, can I combine functions

i.e. String_trim[" ",end](substring[3,6]field_A)

If not, is there another way

Is it possible to user to different key lookups in one lookup stage.

i.e. Field_A.input = B.Code_Table
Field_C.input = B.Code_Table

How do I join multiple fields to one Code table field.

Thanks

I used the modify to convert the CHAR to VARCHAR. Is there a performance difference between the MODIFY and TRANSFORMER stage? Which is better to use?

Thanks