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

Posted on 2005-03-31
Medium Priority
Last Modified: 2012-05-05

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.

Question by:jerrychua
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Author Comment

ID: 13678078
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?

LVL 13

Accepted Solution

ghp7000 earned 2000 total points
ID: 13680904
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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Although it can be difficult to imagine, someday your child will have a career of his or her own. He or she will likely start a family, buy a home and start having their own children. So, while being a kid is still extremely important, it’s also …
Simple Linear Regression
Six Sigma Control Plans
Suggested Courses
Course of the Month7 days, 23 hours left to enroll

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question