MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 5 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: uppercase
jagan

Replies: 2
Views: 2311

PostForum: Database   Posted: Wed Apr 09, 2003 11:26 pm   Subject: uppercase
hi
i have table with all lowecase values in columns.
i want to display them in uppercase.

is there any functions like upper or ucase?

but in my spufi i have given select upper(name) from emp; ...
  Topic: cursors with update
jagan

Replies: 2
Views: 2893

PostForum: Database   Posted: Wed Mar 19, 2003 4:43 am   Subject: cursors with update
i have 100 records in my table and i am using a cursor and i am updating one column in that table.
for the first 50 records it is working fine and i got a problem in 51th record while updating and my ...
  Topic: how to the length of a string
jagan

Replies: 6
Views: 4616

PostForum: Application Programming   Posted: Thu Mar 06, 2003 10:30 am   Subject: how to the length of a string
hi friends,
i want to know the actual length of a value in a variable.
suppose i have a variable xcob with 40 size.
xcob pic x(40)
after i moved some value to that xcob.
is there any length verb ...
  Topic: first 5 records from a db2 table
jagan

Replies: 3
Views: 3972

PostForum: Database   Posted: Tue Feb 18, 2003 2:08 am   Subject: first 5 records from a db2 table
thanks kolusu
is it possible to get last 5 records from a table?in the same way?
  Topic: first 5 records from a db2 table
jagan

Replies: 3
Views: 3972

PostForum: Database   Posted: Mon Feb 17, 2003 3:56 am   Subject: first 5 records from a db2 table
how to retrive first 5 records from a db2 table
pl let me know the answer
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group