Search found 5 matches
- Mon Aug 29, 2011 3:19 am
- Forum: General
- Topic: Finding the last record in a transformer
- Replies: 8
- Views: 4948
- Mon Aug 29, 2011 12:40 am
- Forum: General
- Topic: Finding the last record in a transformer
- Replies: 8
- Views: 4948
@INROWNUM = 2 is not working in datastage 8.5
criteria: data in the file: (has only 2 rows) ABCDEFGHI 123456789 In the output I want it as : 00000ABCDEFGHI00000123456789 stage variables: alphabet:@INROWNUM = 1 number:@INROWNUM = 2 The constraint in the transformer to print the second row is not working (@INROWNUM = 2). Where will we find the pa...
- Tue Oct 23, 2007 2:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: The NLS character map <ASCL_ISO8859-1>
- Replies: 1
- Views: 2349
The NLS character map <ASCL_ISO8859-1>
main_program: The NLS character map <ASCL_ISO8859-1> specified may not be compatible with the character set specified by NLS_LANG;
you may get unexpected results from your database.
you may get unexpected results from your database.
- Mon Aug 13, 2007 2:05 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query in the transformer
- Replies: 3
- Views: 1454
Query in the transformer
Hi If ((IsNull(DSLink2.DUNS_LEVEL_1) =0) And (IsNull (DSLink2.DUNS_LEVEL_2) = 0) And (IsNull( DSLink2.DUNS_LEVEL_3) =1)) Then DSLink2.LEGACY_CD Else DSLink2.DUNS_LEVEL_3 . In the above query it checks that if my first level is not null and my second level is not null and my third level is null, it p...
- Mon Aug 13, 2007 2:04 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Query in the transformer
- Replies: 5
- Views: 1683
Query in the transformer
Hi If ((IsNull(DSLink2.DUNS_LEVEL_1) =0) And (IsNull (DSLink2.DUNS_LEVEL_2) = 0) And (IsNull( DSLink2.DUNS_LEVEL_3) =1)) Then DSLink2.LEGACY_CD Else DSLink2.DUNS_LEVEL_3 . In the above query it checks that if my first level is not null and my second level is not null and my third level is null, it p...