|
From: Alexandre P. <Ale...@ei...> - 2012-03-06 19:11:58
|
If you specify the last column as LD_TS TIMESTAMP NOT NULL WITH DEFAULT DB2 should populate it with the timestamp at the time of load. -- Alexandre Peshansky, MS Senior Bioinformatics Analyst, Research Informatics Core (RIC) Einstein-Montefiore Institute for Clinical and Translational Research (ICTR) Albert Einstein College of Medicine 1300 Morris Park Ave, Mazer Bldg., Rm 534 Bronx, NY 10461 (718) 430-2440 (Mo, We, Fr) (718) 920-4885 (Tu & Th) > -----Original Message----- > From: tells1977 [mailto:ct...@gm...] > Sent: Monday, March 05, 2012 5:49 PM > To: squ...@li... > Subject: [Squirrel-sql-users] Import File Plugin with Timestamp field > > > I am attempting to import a CSV file into a database that has a TIMESTAMP > column. > > Create table DB2.TEST_Table ( > FIELD1 CHAR(18), > FIELD2 CHAR(2), > FIELD3 CHAR(5), > FIELD4 CHAR(2), > FIELD5 CHAR(1), > FIELD6 CHAR(1), > LD_TS TIMESTAMP NOT NULL ) > > My input file would contain FIELDS1 - FIELDS6. LD_TS is the load > timestamp. > I tried using fix format in the import function but I am unable to find a > value that will work correctly. Is there any way to use the import > function and also populate the timestamp field? > -- > View this message in context: http://old.nabble.com/Import-File-Plugin- > with-Timestamp-field-tp33447560p33447560.html > Sent from the squirrel-sql-users mailing list archive at Nabble.com. > > > -------------------------------------------------------------------------- > ---- > Keep Your Developer Skills Current with LearnDevNow! > The most comprehensive online learning library for Microsoft developers > is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, > Metro Style Apps, more. Free future releases when you subscribe now! > http://p.sf.net/sfu/learndevnow-d2d > _______________________________________________ > Squirrel-sql-users mailing list > Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
