ibmi-brunch-learn

Announcement

Collapse
No announcement yet.

FIELDPROC - Field procedure on column ACC080 returned SQLSTATE 38I02.

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • FIELDPROC - Field procedure on column ACC080 returned SQLSTATE 38I02.

    Anyone know why i would be getting this error on the following alter statement?
    Guess there could be a number of possible reasons that require more input, but anyone familiar with this particular issue and what you did to resolve it?

    alter table jfrlib/srvachcc alter column acc080 set fieldproc
    jfrlib/zenc01r

  • #2
    Looks like you need something like this: ALTER TABLE JMALIB/BBCHDSS

    ALTER COLUMN CLASSID

    SET DATA TYPE VARCHAR(20)

    don't know if this helps.

    James

    Comment


    • #3
      Originally posted by jmartin View Post
      Looks like you need something like this: ALTER TABLE JMALIB/BBCHDSS

      ALTER COLUMN CLASSID

      SET DATA TYPE VARCHAR(20)

      don't know if this helps.

      James
      thank you James - just curious how you arrived at that?

      My column ACC080 is a zoned numeric value.

      Comment

      Working...
      X