All forum activity

#DateUserForumTypeThreadPost
2636025 Jul 2012 @ 07:10 PDTterankitToolsReplyMLOAD is assuming one extra line and failing The MLOAD script is: .LOGTABLE logtable; .RUN FILE /work/user/user1; DROP TABLE tab_WT; DROP TABLE tab_ET; DROP TABLE tab_UV; .BEGIN MLOAD   TABLES tab  &...
2635925 Jul 2012 @ 07:08 PDTterankitToolsReplyMLOAD is assuming one extra line and failing How would I know that this is the last record?so that I can write it as "line" in place of line\n?
2635825 Jul 2012 @ 06:55 PDTdemitriToolsTopicDirect output from MVS FastExport to Unix env? Hello everyone! I need to export about 5-6 files from a channel-attached instance, and these files will be consumed by an Unix application. Can I avoid a FTP or somethink alike by "repl...
2635725 Jul 2012 @ 06:39 PDTbarryhullDatabaseTopicColumn parititioning - why does explain show an extra partition? I've just started playing around with column partitioning in R14. I created a table using a recent example that Paul Sinclair put into a recent Teradata Magazine article: CREATE TABLE Sa...
2635625 Jul 2012 @ 06:39 PDTtomnolanGeneralReplyIs there a maven repo out there where I can get the TD artifacts? No, Teradata software is not available from a Maven repository. Teradata software is available for download here on Developer Exchange - http://downloads.teradata.com/ and if you are a c...
2635525 Jul 2012 @ 06:27 PDTulrichToolsReplyMLOAD is assuming one extra line and failing   "Attempted to access out of range input data in field 'IN_TACTIC_ID'"   Is IN_TACTIC_ID the first column in the file?   Do you ha...
2635425 Jul 2012 @ 05:48 PDTnewyorksysTrainingTopicTeradata Online Training & Consultancy by Newyorksys.com Teradata Online Training, Job Oriented Online Course and Placement in USA, NewyorkSys is leading IT Online Training Company in USA. NewYorksys Solutions is an IT Consulting and Online Traini...
2635325 Jul 2012 @ 05:42 PDTterankitToolsReplyMLOAD is assuming one extra line and failing If I will use line\n for the last line then there willl be an empty line at the end which will create issue. that is why I kept it as /nline.
2635225 Jul 2012 @ 05:41 PDTterankitToolsReplyMLOAD is assuming one extra line and failing Please find the MLOAD log: **** 20:20:31 UTY0817 MultiLoad submitting the following request:      BEGIN TRANSACTION; **** 20:20:31 UTY0817 MultiLoad submitting the fo...
2635125 Jul 2012 @ 05:02 PDTulrichToolsReplyMLOAD is assuming one extra line and failing And pease just try once to add a \n at the last line as well...
2635025 Jul 2012 @ 04:46 PDTulrichToolsReplyMLOAD is assuming one extra line and failing can you share the perl code as well?
2634925 Jul 2012 @ 03:53 PDTterankitToolsReplyMLOAD is assuming one extra line and failing In my file there are 6 lines. MLOAD log is saying: considered recoreds: 7 satisfied: 6 out of range "first field" in 7th record. I can post the exact log in some ti...
2634825 Jul 2012 @ 03:46 PDTulrichToolsReplyMLOAD is assuming one extra line and failing can you share the mload log?
2634725 Jul 2012 @ 03:38 PDTterankitToolsReplyMLOAD is assuming one extra line and failing Hi Ulrich, yes, that is why I am writing the first line as "line" and then all the lines as "\nline".In my file there is no new line after last line.No special character....
2634625 Jul 2012 @ 02:51 PDTQaisar Aftab KianiAnalyticsReplyCoverting Char to Date Yes, but you might need to cast the parameter to a proper data format.
2634525 Jul 2012 @ 02:12 PDTKanchanAnalyticsTopicTeradata Database Name change in BO Universe Hi ,   We are developing a universe that contains tables on Teradata. There are 3 environments, development, test and production. Teradata database is on a single machine where the ...
2634425 Jul 2012 @ 12:52 PDTulrichToolsReplyMLOAD is assuming one extra line and failing I am not sure about this. Could you share a test perl script, ddl and mload script? My first guess would be that all lines need to end with a \n. But your last line doesn't. So m...
2634324 Jul 2012 @ 11:43 PDTzlcd1988AnalyticsReplyCoverting Char to Date Hi, I am a newer with the teradata fileld .   I find a sql statement wrote : AND lstg.auct_end_dt < date '$AUCT_END_DT'.   Is it mean to conve...
2634224 Jul 2012 @ 11:19 PDTdnoethDatabaseReplySysdba login - find details Hi Samir, dbc.LogonOffV holds the history of logons/logoffs and there's a column named LogonSource, which includes the network username. The same column is in dbc.QryLogV, but it'...
2634124 Jul 2012 @ 09:44 PDTtd_admirerToolsReplyUsing FILLER in TPT 13.10 Hi Ulrich, Thank you. That worked for me.
2634024 Jul 2012 @ 09:01 PDTvijay007ToolsTopicRegarding TPT... Hi All, When we go for TPT. Performance wise Whic Is Better Fastload or TPT.
2633924 Jul 2012 @ 04:44 PDTterankitToolsTopicMLOAD is assuming one extra line and failing Hi All,   I am creating a text file using perl script and then using that txt file for MLOAD. While writing the first record, I am writing the line as it is. Aftre that I am wri...
2633824 Jul 2012 @ 04:37 PDTteradatauser2DatabaseTopicSysdba login - find details Hi, We have 4-5 people as DBAs. we login with a default id of sysdba. I want to know the individual name , terminal details etc from where one is logging using the common id sysdba. Is t...
2633724 Jul 2012 @ 03:55 PDTteradatatesterDatabaseReplyIs it possible to refresh a view every 15 minutes using a trigger? Thanks!
2633624 Jul 2012 @ 03:08 PDTVandeBergBDatabaseReplyIs it possible to refresh a view every 15 minutes using a trigger? The beauty of views is that you don't have to refresh them.  New or changed data in the base table is reflected in the view without any additional action on the database's part.

Pages