DB2 file names cause SQL error

520 pts.
Tags:
DB2 Web Query
IBM DB2
Metadata
Hello I created metadata over a "set" of files. My next step is to define a primary over one of the files, and then foreign keys over the other files defined in my metadata relational database. Unfortunately, when I attempt to define my primary key over the main file, I receive an SQL error message. I was able to determine that this is attributed to certain field names in the file beginning with special characters such as @, or $ which evidently SQL can not handle. 

 So, my question is, does anyone have a work around, or, do I need to rename all my fields in the relational database prior to creating the metadata? Thank you for your feedback.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Piano
    Hi In the meantime, I created the metadata withouth the join constraints. I am wondering if anyone can help me with 2 additional questions. (1). I have a field called member no, which is actually the social security no. I would like to put a mask on this field, and yet, when I look at th field selection format options, this is not one of the choices. So, not sure how to do this. (2). For now, since I am a beginner in DB2 Web Query Design, I am just querying the main file. (Member master file). I have no selection criteria at this point, and yet when I click on run report, I am only picking up the last record of the Member Master File. In total there are 4.046 records. So, since I don't have any selection criteria, why am I not picking up the other records ? Thank you for your assistance
    520 pointsBadges:
    report
  • Piano
    Hello Well, I realized my confusion with respects to why I was only picking up one member no., when the file that I was querying has over 4,00 members in it. My member no., field was in the sort by window pane, and, was doing a summation by this field. So, the question is, how do I select fields that I want in my report, without having them appear in the sort by window pane. Thank you for your feedback. -Nick
    520 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following