Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2003
    Location
    Raleigh, NC
    Posts
    6

    Question Unanswered: Db2 V 5.1 limitations

    My client is using DB2 Version 5.1 on AS 400. I read from few usenet postings that there is a limitation on the table name and column name size to 18 characters or less.
    Does any of you know of documents that lists this kind and other limitations that I should be aware of while using Version 5.1.
    I couldnt find a posting on this forum on this topic, if there is one could you forward me the link.
    Thanks.

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: Db2 V 5.1 limitations

    http://publib.boulder.ibm.com/iserie...f/rzahfli0.htm

    For some reason, if this link does not work ...

    Your db2/400's SQL Referece has a chapter on SQL Limits
    (But I don't see 18 there)

    Cheers

    Sathyaram

    Originally posted by sudar_ks
    My client is using DB2 Version 5.1 on AS 400. I read from few usenet postings that there is a limitation on the table name and column name size to 18 characters or less.
    Does any of you know of documents that lists this kind and other limitations that I should be aware of while using Version 5.1.
    I couldnt find a posting on this forum on this topic, if there is one could you forward me the link.
    Thanks.
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Aug 2003
    Location
    Raleigh, NC
    Posts
    6

    Re: Db2 V 5.1 limitations

    Thanks Sathyaram. That link threw light on our assumptions.

    Originally posted by sathyaram_s
    http://publib.boulder.ibm.com/iserie...f/rzahfli0.htm

    For some reason, if this link does not work ...

    Your db2/400's SQL Referece has a chapter on SQL Limits
    (But I don't see 18 there)

    Cheers

    Sathyaram

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •