Using RUNSQLSTM in a CL program

I'm just learning how to use RUNSQLSTM in a CL program. In my SQL source member I'm trying to INSERT into a file using a SELECT statement and I'm using the function TRANSLATE on one of the fields I'm selecting. When I call my CL program I'm getting error: "IBM SQL Flagging -- Reserved word TRANSLATE used as an SQL identifier."

Is there a way around this? I really like the fact that I can run multiple SQL statements in one call.

Take a look at the "IBM SQL Flagging" parm (SAAFLAG) in the RUNSQLSTM command and make sure the value is set to *NOFLAG (which is the default). If this parm is set to *FLAG, it basically instructs the system to first check to the statement syntax to determine if conforms to IBM SQL syntax. If it does not conform, you will get the error that you described.

==================================
MORE INFORMATION ON THIS TOPIC
==================================

Visit the ITKnowledge Exchange and get answers to your DB2 questions fast.

Check out this Search400.com Featured Topic: Expert advice on DB2

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: Tips, tutorials and more.

Dig Deeper on DB2 UDB (universal databases)

Running multiple SQL commands within a CL/QMQRY Running multiple SQL commands within a CL/QMQRY does not recognize the semicolon (;) separator. Is there a PTF that is required?

Scheduling a SQL update statement One user writes, "I need to run a SQL Update statement after hours, and it would be nice to schedule it. I saw your posting about the RUNSQLSTM command, but I've had no success with it. I tried saving my command in the STRSQL run, which it saved to a QSQLSESS file, but I still could not use that in the RUNSQLSTM. I need a way to do a STRSQL in a SBMJOB command or through JOBSCHE." DB2 expert Kent Milligan provides a few possible reasons that the command isn't working.

Why am I receiving the error SQL7008? This user is receiving the error SQL7008 message. Site expert Kent Milligan offers some advice.

Writing to a file from CL -- revisited Are you writing from a CL program? This tip writer explains how you can speed up the process.

Simplify export query results This tip will help simplify export query results.

Run multiple SQL statements

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Using RUNSQLSTM in a CL program

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

SQL server error message -321

Choose which column names are returned via ODBC when working with DB2 files

Developing tables in a parent-child relationship in DB2

Have a question for an expert?

Start the conversation

0 comments

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Understand top public cloud repatriation use cases

Microsoft quantum development turns toward hardware

Top 5 options for Linux certifications

Dig Deeper on DB2 UDB (universal databases)

Related Q&A from Kent Milligan

Have a question for an expert?

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.