 |
 |
Archives of the TeradataForum
Message Posted: Wed, 24 Nov 2004 @ 15:23:57 GMT
| Subj: | | Re: IMPORT File and BTEQ 'variables' |
| |
| From: | | Michael Larkins |
| | The change in question is perhaps one of the oldest outstanding ones. I wonder why it is so difficult to implement. | |
Not that I am an expert on UNIX or any operating system (OS), but it would appear that this change being discussed has nothing to do SQL nor
Teradata. The .IMPORT reads a record from a file into a memory buffer. The USING accesses the record from the buffer. After the record is read
the buffer pointer is automatically advanced to the next record by the OS. This is the way it has worked since the beginning of computing for
languages like COBOL, FORTRAN, PL/1, BASIC, etc. To change this would require another OS command or SQL modifier (like USING) that requests the
pointer to advance or in this case: not advance.
A cursor in a stored procedure can be updated in ANSI mode. Maybe writing a stored procedure to change the cursor is a better approach than
changing the file management system in Windows, UNIX and HP-UX.
Just a thought.
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
