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
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
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 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
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
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
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
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
copy from and assign the correct id number?
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
