Execute command on db2/400 fron Sequel Server 2005

[snufse1]

From Sequel Server 2005 I am trying to issue a command to db2/400 using linked server:

exec('call qsys/qcmdexc('OVRDBF FILE(F55125) TOFILE(VGIPRDDTA/F55125) MBR(CO55PC) OVRSCOPE(*JOB)', 0000000071.00000)') at AS400SRV_MSDASQL

Getting syntax error:
Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'OVRDBF'.

The connection works and I have tested this using below example "exec('Select * from vgiprddta.F55125.CO55PC') at AS400SRV_MSDASQL

Any ideas?

 

[mikrom]

The program qsys/qcmdexc has 2 parameters:
1. The command
'OVRDBF FILE(F55125) TOFILE(VGIPRDDTA/F55125) MBR(CO55PC) OVRSCOPE(*JOB)'
2. the length of command
0000000071.00000

These parameters should not be separated by comma but by a space.

Try this in your exec():

CALL PGM(qsys/qcmdexc) PARM('OVRDBF FILE(F55125) TOFILE(VGIPRDDTA/F55125) MBR(CO55PC) OVRSCOPE(*JOB)' 0000000071.00000)

 

[snufse1]

Getting syntax error on

CALL PGM(qsys/qcmdexc) PARM('OVRDBF FILE(F55125) TOFILE(VGIPRDDTA/F55125) MBR(CO55PC) OVRSCOPE(*JOB)' 0000000071.00000)

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'qsys'.

 

[snufse1]

Disregard previous post. Tried this:

exec('CALL PGM(qsys/qcmdexc) PARM('OVRDBF FILE(F55125) TOFILE(VGIPRDDTA/F55125) MBR(CO55PC) OVRSCOPE(*JOB)' 0000000071.00000)') at AS400SRV_MSDASQL

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near 'OVRDBF'.

 

[snufse1]

Got it working this way:

exec('CREATE ALIAS QTEMP.F55125 FOR VGIPRDDTA.F55125 (CO55PC)') at AS400SRV_MSDASQL
exec('Select * from QTEMP.F55125') at AS400SRV_MSDASQL

 

[fredericofonseca]

look at this thread. it may help you.
thread178-1461952

Regards

Frederico Fonseca
SysSoft Integrated Ltd

http://www.syssoft-int.com

FAQ219-2884
FAQ181-2886