DSXchange

thx ray

then how to suppress warnings in server edition

i get the following error,but the job runs succesfully, what does it mean, this error causes the sequence to abort

DataStage Job 602 Phantom 29000
Warning:
[DataDirect][ODBC SQL Server Driver][SQL Server]
Warning:
[DataDirect][ODBC SQL Server Driver][SQL Server]
DataStage Phantom Finished

in my the sever edition, message handler is not enabled

????

can anyone know why?

kcbland wrote:The only solution for you is either environment variables or symbolic links. We've been asking for years to allow this functionality, so instead we got a compile error message.

how can u use envir variable if u cannot use any job parameter in the command path,



thx

so it is impossible to do it with stage variables,

ok arndw

thx arndw, but that would give n rows a output, i want only one row as output(sum).

thx

how to cal sum of n rows using stage variables,

i searched the forum,but could not find

how to cal sum of n rows using stage variables,

i searched the forum,but could not find

thx

how to cal sum of n rows using stage variables,

i searched the forum,but could not find

how to cal sum of n rows using stage variables,

i searched the forum,but could not find

got it

thx kumar

i am not sure what the "awk '{ print $1 }" does in the expression

head -$(expr $(wc -l filename | awk '{ print $1 }') \- 1) filename | tail +2"

Have you checked the previous post? You can use the following to strip out header and trailer. head -$(expr $(wc -l filename | awk '{ print $1 }') \- 1) filename | tail +2 yes i way checking to execute the whole script in the filter command itself, without creating a shell script, anyway thx kumar ...

Use [/quote]

this command filters the header record, how to remove footer row simultaneously . is there a shell script and the head +1 command does not execute at all

how to go abt

thx kumar

how to remove first row and last row,
i am not able to get the exact command to use in the filter command of seq stage, head -1 and tail -1 gives header line and footer line, i want all lines, but header and footer

how to go abt?

thx