Trouble populating output columns
Posted: Tue Mar 16, 2004 6:09 am
Hi all,
I have a server job which results in an Oracle table being populated by either one of two transformer stages.
A large number of these output columns will default to Null. In the first transformer stage, I just set a number of these columns to @Null and use various other derivations for the remaining columns.
If an input column Full_Sample = 'N' The first transformer does not populate the table but passes the data to another transformer which accesses another Oracle table for additional information. Basically the same derivations will be used in both transformer stages to populate the target Oracle table, obvioulsy having different sources for some of the data. When I compile this job, I get the following errors (sample only provided and I hope it display OK):
Compiling: Source = 'RT_BP368/JOB.307061661.DT.1322056336.TRANS2', Object = 'RT_BP368.O/JOB.307061661.DT.1322056336.TRANS2'
************************************************************************************************************************????***
0254 Pin%%V0S27P8.Column%%18 = (@Null)
^
')' unexpected, Was expecting: '('
0255 Pin%%V0S27P8.Column%%19 = (@Null)
^
')' unexpected, Was expecting: '('
0256 Pin%%V0S27P8.Column%%20 = (@Null)
^
')' unexpected, Was expecting: '('
0257 Pin%%V0S27P8.Column%%21 = (@Null)
^
')' unexpected, Was expecting: '('
0258 Pin%%V0S27P8.Column%%22 = (@Null)
^
')' unexpected, Was expecting: '('
0259 Pin%%V0S27P8.Column%%23 = (@Null)
^
')' unexpected, Was expecting: '('
0260 Pin%%V0S27P8.Column%%24 = (@Null)
^
')' unexpected, Was expecting: '('
0261 Pin%%V0S27P8.Column%%25 = (@Null)
^
')' unexpected, Was expecting: '('
0262 Pin%%V0S27P8.Column%%26 = (1)
^
')' unexpected, Was expecting: '('
0263 Pin%%V0S27P8.Column%%27 = ( If Len(Trim(Field(V0S27.Stagevar%%2, "|", 1))) > 0 Then Field(V0S27.Stagevar%%2, "|", 1) Else @Null)
^
')' unexpected, Was expecting: '('
An error is identified for every column from column 18 onwards where various derivations are used. Now if I create stage variables for these derivations and use them to populate the output columns, everything is OK! I don't understand. I have re-entered the derivations/cut and pasted acceptable derivations from columns prior to coulmn 18 - but nothing works.
As per usual, all assistance appreciated - and many thanks in advance!
Cheers
John
I have a server job which results in an Oracle table being populated by either one of two transformer stages.
A large number of these output columns will default to Null. In the first transformer stage, I just set a number of these columns to @Null and use various other derivations for the remaining columns.
If an input column Full_Sample = 'N' The first transformer does not populate the table but passes the data to another transformer which accesses another Oracle table for additional information. Basically the same derivations will be used in both transformer stages to populate the target Oracle table, obvioulsy having different sources for some of the data. When I compile this job, I get the following errors (sample only provided and I hope it display OK):
Compiling: Source = 'RT_BP368/JOB.307061661.DT.1322056336.TRANS2', Object = 'RT_BP368.O/JOB.307061661.DT.1322056336.TRANS2'
************************************************************************************************************************????***
0254 Pin%%V0S27P8.Column%%18 = (@Null)
^
')' unexpected, Was expecting: '('
0255 Pin%%V0S27P8.Column%%19 = (@Null)
^
')' unexpected, Was expecting: '('
0256 Pin%%V0S27P8.Column%%20 = (@Null)
^
')' unexpected, Was expecting: '('
0257 Pin%%V0S27P8.Column%%21 = (@Null)
^
')' unexpected, Was expecting: '('
0258 Pin%%V0S27P8.Column%%22 = (@Null)
^
')' unexpected, Was expecting: '('
0259 Pin%%V0S27P8.Column%%23 = (@Null)
^
')' unexpected, Was expecting: '('
0260 Pin%%V0S27P8.Column%%24 = (@Null)
^
')' unexpected, Was expecting: '('
0261 Pin%%V0S27P8.Column%%25 = (@Null)
^
')' unexpected, Was expecting: '('
0262 Pin%%V0S27P8.Column%%26 = (1)
^
')' unexpected, Was expecting: '('
0263 Pin%%V0S27P8.Column%%27 = ( If Len(Trim(Field(V0S27.Stagevar%%2, "|", 1))) > 0 Then Field(V0S27.Stagevar%%2, "|", 1) Else @Null)
^
')' unexpected, Was expecting: '('
An error is identified for every column from column 18 onwards where various derivations are used. Now if I create stage variables for these derivations and use them to populate the output columns, everything is OK! I don't understand. I have re-entered the derivations/cut and pasted acceptable derivations from columns prior to coulmn 18 - but nothing works.
As per usual, all assistance appreciated - and many thanks in advance!
Cheers
John