开发者

Help with DB2 Error when trying to execute SQL

I开发者_开发知识库 started using the system with a pre-made file called DB2.SQL. I am using this because it is what the tutorial said to use. I then edited this file and replaced the contents with my own code:

CREATE DATABASE BANKDB13 BUFFERPOOL BP0;

When I try to execute a SQL it though, I get this error:

DSNE377A INPUT DATA SET RECFM MUST BE F OR FB WTIH LRECL 80

What does this error mean and how do I correct it on the file?

I am running it with Vista TN3270 on Windows 7 over TSO, in SPUFI mode.

What I've tried so far:

When I start editing the file, I have a screen to change the defualts, and I have changed the RECORD FORMAT to F and FB as well as setting the RECORD LENGTH to 80 with no success.

EDIT:

I resolved the problem by deleting the DB2.SQL file and recreating it, and also making sure that the sizes I gave for the files were consistent with each other.


What SQL are you trying to execute on it?

The error means that the Record Format in the input data set must be either "F IXED" or "F IXED B" LOCK with a logical record length of 80.

So this is what the error means, how to correct it depends on the SQL you're running and the desired outcome.

What Tutorial is it that you refer to, do you have a link? Is this a real world problem, homework or you expanding your knowledge into mainframe DB2?

Your SQL snippet above is creating a DB, what is the INPUT DATASET file format that you are subsequently running SQL on?

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜