topic Re: Opensql Insert statement in Application Development and Automation Discussions

Opensql Insert statement

Former Member — Wed, 03 Dec 2008 12:26:30 GMT

Hi,

I'm currently trying to insert a record in the rsdiobjt table. If this works i have a batch of (similar) query's wich I execute as a one-time update.

In order to do so, i've made the following query:

INSERT INTO rsdiobjt (langu , opbjnm , objvers , txtsh , txtlg) VALUES ('N' ,'0PPM_QNT' , 'Kort' , 'lang John Smith').

When I try to execute the query i get the following error:

"Unable to interpret: (langu , opbjnm , objvers , txtsh , txtlg)"

"Possible causes of error: Incorrect spelling or comma error"

Can anyone tell me what the correct opensql syntax is?

thanks

Re: Opensql Insert statement

Former Member — Wed, 03 Dec 2008 12:29:06 GMT


> Hi,
> 
> I'm currently trying to insert a record in the rsdiobjt table. If this works i have a batch of (similar) query's wich I execute as a one-time update. 
> In order to do so, i've made the following query:
> 
> INSERT INTO rsdiobjt (langu , opbjnm , objvers , txtsh , txtlg) VALUES ('N' ,'0PPM_QNT' , 'Kort' , 'lang John Smith').
> 
> When I try to execute the query i get the following error:
> "Unable to interpret: (langu , opbjnm , objvers , txtsh , txtlg)"
> "Possible causes of error: Incorrect spelling or comma error"
> 
> Can anyone tell me what the correct opensql syntax is?
> 
> thanks

Hi Jong,

I think it is due to space after every field in your query.

Just try like this.

INSERT INTO rsdiobjt (langu, opbjnm, objvers, txtsh, txtlg)

VALUES ('N', '0PPM_QNT', 'Kort', 'lang John Smith').

Hope it will be useful to you.

Thanks

Nitesh

Re: Opensql Insert statement

Former Member — Wed, 03 Dec 2008 12:29:56 GMT

Hi,

Use UPDATA DBTAB with SET key word

please go through the KEY word documentation for further info there you will find an example too

Regards

Ramchander Rao.k

Re: Opensql Insert statement

Former Member — Wed, 03 Dec 2008 12:33:34 GMT

declare a workarea (wa_itab) with the same structure as of rsdiobj.

The values u want to insert are 2 be assigned to the corresponding fields in the work area.

Then use the stmt

INSERT INTO rsdiobjt VALUES wa_itab.

the fileds which r nnot reqd 2 be inserted can be left blank in the workarea.

Regards

Winnie