To insert multiple rows in temporary table

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

Hi,

I am inserting multiple rows in temporary table in cobol program. Then I am fetching each value. While fetching it is giving sqlcode 100 and there is no value.

But when i tried with inserting only one value alone. It gave me sqlcode 0. Please suggest me. The temporary table declaration is

enrico-sorichetti · Posted: Mon Nov 17, 2008 1:44 pm

if You expect to fetch multiple rows You should use a cursor

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

yes I am using a cursor to fetch. but for inserting muyltiple rows should I use cursor?

enrico-sorichetti · Posted: Mon Nov 17, 2008 1:56 pm

my bad for the previous reply ( I was doing neuronic multitasking )

status code 100 is a legitimate status code for no row fetched
which means.... no rows found for a single fetch
no more rows found for a cursor fetch

I guess You should review Your query

insert is an insert and has nothing to do with a cursor

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

Thank you enrico for your efforts. The problem has solved in multiple rows insert. The insert should not contain "values" keyword. That I removed and now it is working fine.

Bharath Bhat · Posted: Tue Nov 18, 2008 10:26 am

AFAIK an insert must contain values clause. Just that I am curious, can you please post your insert statement?

birdy K · New User Joined: 05 Mar 2008 Posts: 72 Location: chennai

For multiple row insert , for ex