[Mark Wong wrote] > Sent: Freitag, 8. Februar 2002 01:10 > To: [EMAIL PROTECTED] > Subject: RE: Function to return current date or timestamp? > > > Ah, thanks for pointing that out. I can see that refers to > inserts and > updates, but can it be used for a fastload or tableload? > > Thanks, > Mark > Hi Mark, the functions DATE, TIME, and TIMESTAMP can be used for fastload and dataload (see the repman manual for fastload command at page 33: fastload -> load_column_spec_mlt -> load_column_spec -> column_assignment -> generate_spec).
With tableload those functions can't be used because tableload does not load data record oriented but page oriented - which simply means that tableextract extracts the data as pages as they are on the database and tableload loads these pages again. HTH. Regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
