Search found 4 matches

by harimca
Tue Apr 10, 2007 11:18 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: to overcome -407 error in Db2
Replies: 5
Views: 9743

Hi Veera

Thanks a ton for helpign in this issue,I got in touch with the users and they are ok
to pass soem default value say 'Y' for the timebeing ,I need to confirm with DBA on this issue for removing the column / changing to default value at DDL

Will sure let you know for any Updates.
by harimca
Wed Apr 04, 2007 6:43 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: to overcome -407 error in Db2
Replies: 5
Views: 9743

They wanted to remove this field from 1 of the frontend screens ,so i have to go with commenting or else as u said talk to DBA and get it done Initialised to Default if it not Defaulted

Can please gimme some more inputs on this\\


thanks veeraa
by harimca
Wed Apr 04, 2007 9:44 am
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: to overcome -407 error in Db2
Replies: 5
Views: 9743

to overcome -407 error in Db2

Hi
I need to comment a feild in a Insert query,which is declared as notnull,when it is trying to insert the query its throwing the -407error.

can any one advice me on this...plz
by harimca
Tue Mar 27, 2007 7:22 pm
Forum: DB2 SQL - DB2 PROGRAMMING
Topic: To update a Comment in Lower case in DB2
Replies: 1
Views: 6720

To update a Comment in Lower case in DB2

Hi

Is there any way to update a String in Lower case in DB2 ,By default it is taking all in CAP's Please do the needfull bit Urgent

Thank you all.