• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

[500 points] NATURAL - How to catalog with XREF ON.


While trying to get my Natural program to use Static SQL, I come across an error:

STAT9033 No XREF data exist for member <member>.
Either the Natural program which is to be statically generated cannot be cataloged with XREF=ON or the XREF data are not on the used Predict file.

So basically my question is this:
What's the command line for Cataloging with parameter XREF set to Y/YES/ON ?

Due to the urgency, this is worth 500 points.

1 Solution
jerrychuaAuthor Commented:
additional details:

os/390 mainframe
Natural for DB2

Basically, what i'm trying to do is create the XREF.
I understand that precompiling my Natural program should create my XREF. The precompilation (CMD CREATE DBRM ... WITH XREF YES ...) executed successfully, and i got my DBRM, but no XREF. apparently. [dunno how to check, though]

Any reason why cataloging with XREF ON wouldn't work?

Again, I'm no expert in Natural or Predict, but the reason the cmd create succeeds is because the xref parameter is optional, what I mean is when you specificy xref=on with cmd create, it just tells the system to turn this feature on when the program is run.
But, as you know, when you run the program, you are getting error message stat9033, which means one of TWO things:
1: the necessary modules for this feature to work are not installed on the system or
2: your natural program cannot be cataloged wwith the xref feature on

Therefore, check to make sure you have all the necessary support libraries for XREF, or simply turn the feature off and run the program again and see if you get the same error message

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now