DSXchange

do you know how to find the MAX salary, similar logic will apply in your job

you need not to restart the server.

do you know the ID for this job??

just check, if there is any lock for any process or job of this ID , and clear that.

use execute command

read the datastage online manual , designer guide

searching "DS_JOBOBJECTS does not exist" may help you, and probably this post

viewtopic.php?t=113318

try to use some other alias name for col5

col1,
col2,
col3,
col4,
decode(Col5,null,'A','B') check_flag
from Table1

This parameter $APT_GRID_HEAD_PATITIONS is available in version 3.3.2 of grid toolkit.

because it works.
$APT_GRID_HEAD_PATITIONS=2 will generate two condutor node partition not any compute node on head node. the other partition on head node will be used to generate node map.

1. Add another parameter $APT_GRID_HEAD_PARTITIONS = 2 (must be more than 1)
2. Do not use host qualifier for the sequential file . Means remove the $APT_GRID_SEQFILE_HOST preffix from the file path
so it will be File=/pathname/*.txt ; rather than File=$APT_GRID_SEQFILE_HOST/pathname/*.txt

Does DRS stage use ODBC?? or the native client connection??

the error is because of this .
it is because of the license issue.
i was having this issue, and the IBM support advice me about this.

Do you see anything like QEWSD=...... , just next to the ODBC name in the .odbc.ini file

[DSO9ITMP]
QEWSD=39646
Driver=/u01/app/Ascential/DataStage/branded_odbc/lib/VMor820.so

de select the "Record length = fixed " option

i am geeting this message in a job, can someone tell me what is actually this means :

main_program: APT_SortedGroup2Operator::describeOperator nkeys: 1

add this parameter -param '$APT_CONFIG_FILE=<configuration file name with path>'

what are the stages you have in the job?