Is it possible to have a sequence (or something like it) when it increments
alpha-numeric?
Say the first value is set at A01 and it will increment to A02, A03 by
default. Also, it would be good if it could be made the primary key.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
u can set
the initial value to alphanumeric and it will increment from there.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Gannon, Terry" <[EMAIL PROTECTED]>
To: "'Adam Lang'" <[EMAIL PROTECTED]>
Sent: Friday
Is it possible to copy from a text file that has the fields as fixed width
with no delimiter to a table?
The other option is a CSV file... but then how do I handle if there is a
comma in one of the fields?
I'm transfering information from an AS/400 ... if it is into a text file, it
is fixed widt
Sort of nevermind, can I can save it tab delimited, but I am still curious
if it can be done using fixed width fields.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Adam Lang" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
S
copy from and assign the correct id number?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
I get it. I upload to the temp table, then for the select/insert I just do
the nextval(seq_id) for the primary key field, correct?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: &qu
I believe you are correct. Version 7.1 will supposedly eliminate the row
size.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Thomas Swan" <[EMAIL PROTECTED]>
To: "Keith Wong" <[EMAIL PROTECTED]>; <[EMAIL P
Hmmm... well, I don't think I have an "explicit" nextval. I created the
table and then I did a create sequence broker_id;
Are you implying that I can set the field to automatically create a nextval?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Mes
Gotcha. Now, if I do an insert and just don't specify that field at all, it
will, use the default value, correct? As long as I don't "touch" the field
with anything it uses the default.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message
