SQL server error message -321

To solve the SQL error -321 on IBM i6.1, use the new values statement to overcome the error. If you are using an older release, declare a cursor using dynamic SQL.
Choose which column names are returned via ODBC when...

When working with DB2 files with columns that have both short and long names, there is no option choose which column names are returned via ODBC because SQL-based interfaces use the long column nam...
Developing tables in a parent-child relationship in DB2

When developing tables in a parent-child relationship, use a primary key and a foreign key along with a unique ID to make your database easier to maintain over time.
When is the YES option for 'reuse deleted files' fun...

IBM did not change the default of the reuse deleted files function to YES for physical files in order to minimize the impact on any existing applications that may have dependencies on deleted recor...

DB2 UDB (universal databases)

Email Alerts

Register now to receive Search400.com-related news, tips and more, delivered to your inbox.

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

Translation from ASCII to EBCDIC

Ask the Expert
Working with commit and rollback statements

Ask the Expert
Poor response time when running a SQL select statement

Ask the Expert
Copy multiple files into one DB2 file

Ask the Expert
Running stored procedures

One Search400.com user writes, "I would like to run a stored procedure on the iSeries to populate a table in Microsoft Access. Are their any examples in VB or Java? What is the best method?" DB2 expert Kent Milligan responds. Ask the Expert
Example of the CPYTOIMPF CL command

Ask the Expert
DB2 Control Center and the iSeries

Ask the Expert
Change the length of an existing field

Ask the Expert
Index covering and DB2 query performance

There are situations when putting the most selective column last speeds up a DB2 query. Here is the explanation. Tip
Example code for Visual Basic 6.0

Ask the Expert

E-Books

E-Zines

E-Handbooks

Topics

Hot Topics

Advice & Tutorials

Technology Dictionary

Tips

Answers

Ask a Question

Research Library

Product Demos

Blogs

DB2 UDB (universal databases)

Email Alerts

More from Related TechTarget Sites