Re: Insert Errors - Specific Fields

[GYousefpou <GYousefpou@AOL.COM>]

Hi Chris;

Boy this error looks very familiar.:)
In PeopleSoft all fields are requiered.  They can be blank, but not Null.  I
am sure you know Null is different than Blank.  However, date fields can be
null unless they are Effective date which is a key in an effective dated
table.  I give you two possiblities:
1.  You are inserting the value of one field into another field in table.
  example:

  insert into ps_table(
  Name,
  humer_level,
  address)
  values (
  John,
  '1111 wall street' )

2.  you have miss a field or  miss typed it.

in any given case

put shows  right before insert statment and check the value you are about to
insert.

for example

show '<'  variable_name '>'

when the sqr stopped go back to your sqr.lis(usually in your temp directory of
your local drive) file and check to see what is wrong.

If you are not clear let me know by
email(gilbert.yousefpour@firstdatacorp.com) or you can call me between 9- 6
central Standard Time at my work.  The number is (402)  222-7692.  It is a
direct line.

good luck :)

Gilbert