Hi All,

I want to insert rows using procedure.
I have created the procedure using below mentioned code.

-STARTLOAD
MODIFY FILE PURCHASED_WATER_TMP
FREEFORM PURCHASED_DATE/YYMD
FREEFORM PURCHASED_WATER/P33.4
FREEFORM USER_NAME/A10
FREEFORM GROUP_ID/A10
FREEFORM CREATED_DATE/A50
DATA
2012-02-09,43.56,'user','group',&DATEYYMD &TOD
END
-RUN

I am getting error as

(FOC1400) SQLCODE IS -1 (HEX: FFFFFFFF)
: Microsoft SQL Server Native Client 10.0: [] Null accessors are not supported by this provider.
(FOC1740) EXECUTE ERROR : PURCHASED_WATER_TMP
0 TRANSACTIONS: TOTAL = 1 ACCEPTED= 1 REJECTED= 0
SEGMENTS: INPUT = 0 UPDATED = 0 DELETED = 0

Please suggest me where I am wrong.

Thanks,
Chiranjeevi A.

This message has been edited. Last edited by: Kerry,

quote:

Null accessors are not supported by this provider.

I don't use MODIFY myself so I cannot really give you any hints about the syntax you're using so I'll assume it is fine.

However, the error message you're getting comes directly from your database (MS SQL) so apparently there is a NOT NULL field in your table you're not sending a value for and the DB is complaining about that.

If you show us what the table structure is plus the contents of its related synonym (masterfile) that will allow us to better spot what may be wrong.

Please don't forget to enclose your code and table structure in "code tags" (check the </> button in the message's toolbar).

May want to open the Manual:

-STARTLOAD
MODIFY FILE PURCHASED_WATER_TMP
FREEFORM PURCHASED_DATE/YYMD
FREEFORM PURCHASED_WATER/P33.4
FREEFORM USER_NAME/A10
FREEFORM GROUP_ID/A10
FREEFORM CREATED_DATE/A50
MATCH KEY_COLUMN
ON MATCH UPDATE *
-* OR Unique Columns in the Segment
ON NOMATCH INCLUDE
DATA
2012-02-09,43.56,'user','group',&DATEYYMD &TOD, $
END
-RUN

quote:

May want to open the Manual

Agreed.

Letting MODIFY finish the code may be easy, but its far better to control how you are going to process the data.

You want to insert data, but what you have may update data as well, as it will check for existing keys. Do you want this to happen ?, should you handle existing keys ?.

Hi njsden,Tom,Waz

As of now I am working only on inserting data which is working fine.

Thanks for your suggestions.

Regards,
Chiranjeevi A.