Q
Problem solve Get help with specific problems with your technologies, process and projects.

Dynamic SQL statement in an RPG program

DB2/400 and DB2 UDB expert Kent Milligan discusses how to substring a character field on an SQL join statement.

Kent Milligan
IBM
In a dynamic SQL statement embedded in an RPG program, is it possible to substring a character field on a join statement? One of the join files has two fields -- one is numeric 3.0 and the other is numeric 4.0. Is it possible to join that file with one that has matching data in a 7-byte character field?
Yes, the SQL join criteria can contain expressions such as the following: SUBSTR(1,3,T1Col1)=T2Col

You could define an SQL view with this substring expression to simplify the SQL that's coded into your application.

This was last published in February 2008

Dig Deeper on RPG iSeries programming

Have a question for an expert?

Please add a title for your question

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

You will be able to add details on the next page.

Meet all of our AS/400 experts

View all AS/400 questions and answers

Start the conversation

Send me notifications when other members comment.

Register

Please create a username to comment.

-ADS BY GOOGLE

SearchDataCenter

Close