Search found 6 matches
- Mon Jan 24, 2005 8:37 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: SQL within Server Routine
- Replies: 2
- Views: 1160
SQL within Server Routine
I do not have much SQL knowledge so I need some help please. I have a SQL statement within a Server routine and I call the DSExecute command but within the statement I only want to bring back 1 answer I know there is the ROWNUM but it does not seem to like it If this ROWNUM is correct do I put it in...
- Thu Jan 20, 2005 11:34 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error within a Server Routine
- Replies: 7
- Views: 2782
Re: Error within a Server Routine
Seem to have sorted the problem.
Its in the wrong table space so this may sort it
Its in the wrong table space so this may sort it
- Thu Jan 20, 2005 11:03 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error within a Server Routine
- Replies: 7
- Views: 2782
- Thu Jan 20, 2005 10:50 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error within a Server Routine
- Replies: 7
- Views: 2782
- Thu Jan 20, 2005 10:22 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error within a Server Routine
- Replies: 7
- Views: 2782
Re: Error within a Server Routine
The entry parameters are InCurrencyFrom InCurrencyTo InTransactionDate This is the Code CurrencyFrom = Trimf(Trimb(InCurrencyFrom)) If Trimf(Trimb(InCurrencyTo)) = '' OR IsNull(Trimf(Trimb(InCurrencyTo))) Then CurrencyTo = 'USD' End Else CurrencyTo = Trimf(Trimb(InCurrencyTo)) End If Trimf(Trimb(InT...
- Thu Jan 20, 2005 10:09 am
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Error within a Server Routine
- Replies: 7
- Views: 2782
Error within a Server Routine
I have the following SQL running witin a server routine but I keep getting an error. Has anyone any ideas. The SQL is "SELECT J_C1CRR , '|', J_C1CRRD FROM PS_JWS_F1113 WHERE ROWNUM = 1 AND J_C1RTTY = 'S' AND J_C1CRCD = '":CurrencyFrom:"' AND J_C1CRDC = '":CurrencyTo:"' AND J...