Re: How can i retrieve all field attribute through SQLstatement Describe(SQLDA)

message: 9

  
never use MS SQL server before , can you describe how to use the file
SYSCOLUMNS

date: Wed, 9 Aug 2006 12:55:44 -0400
from: rob@xxxxxxxxx
subject: Re: How can i retrieve all field attribute through
SQLstatement Describe Table(SQLDA)

Describe table is one way. Have you thought of querying the file 
QSYS2/SYSCOLUMNS? If you have any experience with MS SQL Server then it 
might even look familiar to you.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





"2046 BBQ"  
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
08/09/2006 10:39 AM
Please respond to
RPG programming on the AS400 / iSeries 


To
RPG400-L@xxxxxxxxxxxx
cc

Subject
How can i retrieve all field attribute through SQLstatement Describe 
Table(SQLDA)






1. I have tried to use Describe Table statement to retrieve file field
attribute, but i don't know what
meaning of SQLLEN (because it is a binary field, how to 
translate)
2. How i know when the field is DBCS
-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




------------------------------

-- 
This is the RPG programming on the AS400 / iSeries (RPG400-L) digest list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.



End of RPG400-L Digest, Vol 5, Issue 910
****************************************