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

Select from logical file

I'm trying to access a logical file through ODBC. The problem: When I check the results, the information presented is not sorted at all and it shows the contents of the regular physical. I'm using CA Express ODBC V5R1.

As far as I now, this is not an ODBC issue, rather then SQL issue. When selecting records from SQL table, you cannot assume anything on the order of the rows (that is SQL is allowed to return the rows anyway he likes).

Add order by clause to your statement (it will use the lf for the sorting), for example: Select empno, empname from emp order by empno.


Ask your systems management questions--or help out your peers by answering them--in our live discussion forums.

The Best Web Links: Tips, tutorials and more.

Dig Deeper on FTP

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.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.