|26360||25 Jul 2012 @ 07:10 PDT||terankit||Tools||Reply||MLOAD is assuming one extra line and failing||
The MLOAD script is:
.RUN FILE /work/user/user1;
DROP TABLE tab_WT;
DROP TABLE tab_ET;
DROP TABLE tab_UV;
TABLES tab &... |
|26359||25 Jul 2012 @ 07:08 PDT||terankit||Tools||Reply||MLOAD 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?
|26358||25 Jul 2012 @ 06:55 PDT||demitri||Tools||Topic||Direct output from MVS FastExport to Unix env?||
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... |
|26357||25 Jul 2012 @ 06:39 PDT||barryhull||Database||Topic||Column 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... |
|26356||25 Jul 2012 @ 06:39 PDT||tomnolan||General||Reply||Is 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... |
|26355||25 Jul 2012 @ 06:27 PDT||ulrich||Tools||Reply||MLOAD 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... |
|26354||25 Jul 2012 @ 05:48 PDT||newyorksys||Training||Topic||Teradata 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... |
|26353||25 Jul 2012 @ 05:42 PDT||terankit||Tools||Reply||MLOAD 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.
|26352||25 Jul 2012 @ 05:41 PDT||terankit||Tools||Reply||MLOAD is assuming one extra line and failing||
Please find the MLOAD log:
**** 20:20:31 UTY0817 MultiLoad submitting the following request:
**** 20:20:31 UTY0817 MultiLoad submitting the fo... |
|26351||25 Jul 2012 @ 05:02 PDT||ulrich||Tools||Reply||MLOAD is assuming one extra line and failing||
And pease just try once to add a \n at the last line as well...
|26350||25 Jul 2012 @ 04:46 PDT||ulrich||Tools||Reply||MLOAD is assuming one extra line and failing||
can you share the perl code as well?
|26349||25 Jul 2012 @ 03:53 PDT||terankit||Tools||Reply||MLOAD is assuming one extra line and failing||
In my file there are 6 lines.
MLOAD log is saying:
considered recoreds: 7
out of range "first field" in 7th record.
I can post the exact log in some ti... |
|26348||25 Jul 2012 @ 03:46 PDT||ulrich||Tools||Reply||MLOAD is assuming one extra line and failing||
can you share the mload log?
|26347||25 Jul 2012 @ 03:38 PDT||terankit||Tools||Reply||MLOAD is assuming one extra line and failing||
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.... |
|26346||25 Jul 2012 @ 02:51 PDT||Qaisar Aftab Kiani||Analytics||Reply||Coverting Char to Date||
Yes, but you might need to cast the parameter to a proper data format.
|26345||25 Jul 2012 @ 02:12 PDT||Kanchan||Analytics||Topic||Teradata Database Name change in BO Universe||
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 ... |
|26344||25 Jul 2012 @ 12:52 PDT||ulrich||Tools||Reply||MLOAD 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... |
|26343||24 Jul 2012 @ 11:43 PDT||zlcd1988||Analytics||Reply||Coverting Char to Date||
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... |
|26342||24 Jul 2012 @ 11:19 PDT||dnoeth||Database||Reply||Sysdba login - find details||
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'... |
|26341||24 Jul 2012 @ 09:44 PDT||td_admirer||Tools||Reply||Using FILLER in TPT 13.10||
Thank you. That worked for me.
|26340||24 Jul 2012 @ 09:01 PDT||vijay007||Tools||Topic||Regarding TPT...||
When we go for TPT. Performance wise Whic Is Better Fastload or TPT.
|26339||24 Jul 2012 @ 04:44 PDT||terankit||Tools||Topic||MLOAD is assuming one extra line and failing||
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... |
|26338||24 Jul 2012 @ 04:37 PDT||teradatauser2||Database||Topic||Sysdba login - find details||
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... |
|26337||24 Jul 2012 @ 03:55 PDT||teradatatester||Database||Reply||Is it possible to refresh a view every 15 minutes using a trigger?||
|26336||24 Jul 2012 @ 03:08 PDT||VandeBergB||Database||Reply||Is 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.