Search found 6 matches

Go to advanced search

by technokrat
Fri Jun 19, 2009 1:31 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Usage of CASE in SQL QUERY
Replies: 2
Views: 6029

Thanks for help :)
by technokrat
Fri Jun 19, 2009 12:35 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: Usage of CASE in SQL QUERY
Replies: 2
Views: 6029

Usage of CASE in SQL QUERY

can anyone suggest me the usage of CASE statement in an sql query????


Thanks in advance..... :)
by technokrat
Wed Jun 17, 2009 3:09 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: INSERT MORE THAN ONE ROWS IN SPUFI
Replies: 13
Views: 26767

Can u plz modify the above query for using UNION ??? :?:
by technokrat
Wed Jun 17, 2009 2:56 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: INSERT MORE THAN ONE ROWS IN SPUFI
Replies: 13
Views: 26767

its a 8.1 version
by technokrat
Wed Jun 17, 2009 2:27 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: INSERT MORE THAN ONE ROWS IN SPUFI
Replies: 13
Views: 26767

SQLCODE = -104, ERROR: ILLEGAL SYMBOL ",".
by technokrat
Wed Jun 17, 2009 2:04 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: INSERT MORE THAN ONE ROWS IN SPUFI
Replies: 13
Views: 26767

INSERT MORE THAN ONE ROWS IN SPUFI

HI, can anyone help me out in inserting two rows at a time i tried with the following syntax but it gave me error. INSERT INTO EMPLOYEE(EMPNAME,SALARY,LOCATION) VALUES('RAJU',8888,'BANGALORE'), ('JOHN',7777,'CHENNAI'), ('KEVIN',7676,'NEW YORK'); :?:

Go to advanced search