DSXchange

Hi,
I am accessing DB2 thru ODBC I am getting following error:

DIR_MK..DIR_DPK: DSD.BCIConnect connecting to DBNAME,
call to SQLConnect failed.
SQLSTATE=08S01,
DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver]
Connection refused. Verify Host Name and Port Number.

Thanks for posting link that resolve my problem. I used following from that post: Click on ok, and under locks, select Show All. You might find your job. Note down the PID. Select the PId from Process block. Now again click on show by process under Locks. Click on release All. Try to use dsadm user ...

When I am opening the job it says that the Job is being access by other user but when I see in Director for cleanup resource it says me : ERROR: Cannot find any process numbers for stages in job hir_lre_aro_side I tred in Admin. also by 'ds.tools' but it also giving me same massage. How can I resolv...

Yes :D It is done. I used 1st code and Job run successfully.
Thank you very much for the help.

Can you tell me why we need this ?

Thanks a lot

Number is 35.
Jobparameter type is integer.

Thanks for that

Now I am getting following massage:
Message:
k_ren..JobControl (@Job_Activity_7): Controller problem: Error calling DSSetParam(Return), code=-4
[ParamValue/Limitvalue is not appropriate]

Can you help me ? please ?

Try the 'type filename.txt' from command prompt

I dont have UNIX command prompt. BUT I am passing the same path which I used while generating flat file.

Thank you very much for responce I passed type /demo/....../filename.txt but still it is giving me following massage: k_ren..JobControl (@Execute_Command_2): Command type /demo/....../filename.txt did not finish OK, reply = '1' AND Message: k_ren..JobControl (@Job_Activity_7): Controller problem: Er...

You were supposed to 'type' the file, not try to execute it.

I am typing complete file path in COMMAND block of Execute Command

What does the log say? is: Message: k_ren..JobControl (@Execute_Command_2): Executed: /demo/...../filename.txt Reply=320 Output from command ====> SH: /demo/....../filename.txt: 0403-006 Execute permission denied. AND Message: k_ren..JobControl (@Execute_Command_2): Command /demo/......../filename....

Thanks for the Replay.

When I am using Execu_command.$Command_Output as value, then the Sequence gets aborted...what can be reason ?

I did that and sequence is running fine. BUT output of command is giving me wrong value what can be reason ? In command_line, I am passing path of my .txt file which contain only single digit and that digit I am passing as parameter of next job_activity..BUT output of this activity is giving me wron...

During run time, the contents of that file can be passed to the job parameter.

Can you please tell me how to do this ? I have read this..in other forums But I want to know how ? please let me know..

Hi, I am Really stuck please help me.. I have job which generates surrogate key using Surrogate_key_gent_stage, I want to maintain surrogate key in multiple run, I search in forum I found that I can do with Sequence BUT can anyone please tell me how to retrive Last_run_max_value of surrogate key in ...

You can alternatively limit the row from the source of the exisining job design through a parameter. If the source is from DB and if you have a Userdefined SQL, have a extra condition in WHERE class as 1=2 for no rows to extract and 1=1 for normal cases. Or if you have transformer, use @INROWNUM =0...