No sorting in the temp table

[Kayal]

I have 26k records in a file ( say, Input ), and I want to pass it to the temp table in the same order that I have in my input file ; How is this possible?

 

[TomBascom]

I'm not sure what you mean by "pass", I'm assuming that you mean that you wish to populate a temp-table with the contents of a file. Here is an example:

/* given a file named "data.txt" whose contents are:
abc
xyz
def
fred
george
xyzzy
 */

define temp-table tt_example no-undo
  field f1 as character format "x(30)"
.

input from value ( "data.txt" ).
repeat:
  insert tt_example.
end.
input close.

for each tt_example:
  display f1.
end.

Your actual problem likely has a more complicated structure

In this example the key to "in the same order" is that I did not bother to create an index on the temp-table. That may, or may not, be a suitable solution for your problem space. But given the lack of insight into what you actually need I have decided to go with a minimalist approach. Clarified requirements might result in a different approach.

 

[tamhas]

By the same token, if the above satisfies your need, you could use a WORK-TABLE instead of a TEMP-TABLE.

 

[TomBascom]

Yes. But using work-tables with large data sets is risky. It is very easy to exhaust memory that way. And if you happen to do that on the server the server will crash.

 

[tamhas]

True enough ... but testable. I just think that people forget about work-tables these days, but they are a good fit for some use cases.

 

[TomBascom]

Until some nimrod drops a 100GB data file when you've only tested that it works with 26k...