|
|
|
Junior Member
 
Group: Forum Members
Last Login: 11/6/2008 6:51:57 AM
Posts: 11,
Visits: 169
|
|
Hi all.
I'm trying to find a way to get the record number (recno) of a record in the INFILE and use it as an insert value, but I've not been able to sort it out.
I've tried &SYSRCDCNT in several ways, but still no avail.
TIA.
Cheers.
Carlos.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 4:01:17 PM
Posts: 91,
Visits: 118
|
|
Use an IDENTITY column:
http://www.teradataforum.com/teradata/20040526_023940.htm
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 11/6/2008 6:51:57 AM
Posts: 11,
Visits: 169
|
|
Jeff:
If I wanted to use an IDENTITY column, I would have used it.
My requirement -and I think I expressed it specifically- is to use the file record number.
If there is a way in multiload to access the record number, and you know it, and you are so kind to provide it, OK.
Otherwise, don't throw 'wise guy' answers.
Cheers.
Carlos.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 4:01:17 PM
Posts: 91,
Visits: 118
|
|
|
This was not a wise guy answer. Thanks for the wonderful feed back.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 11/18/2008 6:27:19 PM
Posts: 23,
Visits: 76
|
|
To my knowledge neither FastLoad or MultiLoad have a mechanism to allow you to perform this task.
Your two options are (as previously, correctly suggested) firstly to use an Identity column (although record numbering will not be sequential), or secondly to develop an INMOD/Batch script (Unix shell script is an alternative) to modify the data file before the load takes place.
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: 11/6/2008 6:51:57 AM
Posts: 11,
Visits: 169
|
|
>>"To my knowledge neither FastLoad or MultiLoad have a mechanism to allow you to perform this task."
OK. Many Thanks. This was the answer that I was looking for.
>>"Your two options are (as previously, correctly suggested) firstly to use an Identity column (although record numbering will not be sequential),"
Wrong. Identity column was not 'correctly suggested' since my requirement demands a relationship between the file record number and one attribute (column) in the table.
>>" or secondly to develop an INMOD/Batch script (Unix shell script is an alternative) to modify the data file before the load takes place."
Yup. The shell scripting was the way I took...
Thanks.
Cheers.
Carlos.
|
|
|
|