#DateForumTypeThreadPost
45526 Oct 2008 @ 10:59 PDTToolsReplysetting BTEQ Import attribute dynamicallyIf you are doing it from Unix/Linux, you can do it in two stages.first bteq to get the filename and path from the control tablebteq <<-END.login.......set ....... (turn of title dashess etc ....
45424 Oct 2008 @ 10:37 PDTAnalyticsReplyReducing runtime for a MLOAD jobif you are loading empty table, can you try fastload ? mload has to go through the way of a work table.
45324 Oct 2008 @ 10:36 PDTDatabaseReplydefault charactersetOne trick is to use the translate function in the select to explicitly state the fields as LATIN
45224 Oct 2008 @ 10:31 PDTDatabaseReplyHow to capture procedure out parameter value into unix variable?you can't dump the o/p variable of stored proc directly to the shell.The approach you should take is probably do a .export to a file and read it from there..
45123 Oct 2008 @ 11:26 PDTToolsReplythe smart QueryMan for this Query !!! Convert Rows to ColumnsYou can't have a dynamic number of columns in the o/pbut if you are just looking for one column field that holds all these values, then you can use recursion to achieve it.
45023 Oct 2008 @ 11:25 PDTToolsReplyBTEQ RUN FILE Warning messageif you are so particular about it, then this is the way ...(cat loginFilecat MySQLsFileecho ".QUIT;") | bteq
44923 Oct 2008 @ 11:15 PDTAnalyticsReplyReducing runtime for a MLOAD jobWhat is the number of existing records in the table ?Also can you load the file to an empty table and tell us if that's any faster ?
44822 Oct 2008 @ 11:22 PDTDatabaseReplyIssue with stored procedure INOUT parameterYou can explicitly cast your input.call sp_getval('abc' (VARCHAR(300)))You are most likely hitting this problem, because SQL assistant is using the i/p variable data type to bind the o/p which is c...
44722 Oct 2008 @ 12:45 PDTDatabaseReplyHow to Wait, Pause or SleepFew ways to approach.Pass the timestamp as argument to the initial proc call, and then it can increment it and pass it on to the next call etc...mySP(ts timestamp){do stuff...(if call again) call m...
44621 Oct 2008 @ 09:03 PDTDatabaseReplyHow to Wait, Pause or SleepThere's a tricky way I can think of ( or probably a bunch of tricky ways to explore)...But why are trying to do it ? is it for debugging purposes ?There could be a better way to do it that we might...
44520 Oct 2008 @ 09:18 PDTDatabaseReplyError while trying to connect to Teradatayou can run it from any of the teradata nodes ...
44420 Oct 2008 @ 09:17 PDTToolsReplyFast Load errorI wonder if the ^M characters have popped into the file because it was edited in windows ?try doing a dos2unix and run it again ...
44317 Oct 2008 @ 07:40 PDTDatabaseReplyBTEQ inserts unwanted newlineI am not sure which version of the doc you are referring to..To quote TTU 8.2 doc (which is also not the latest)The valid range is from 20 to 65531
44217 Oct 2008 @ 05:17 PDTDatabaseReplyBTEQ inserts unwanted newlineif you are still not running in old versions of bteq, increase the width.SET WIDTH 10000 ( or so ...)
44116 Oct 2008 @ 09:39 PDTDatabaseReplyString function to reverse searchRecursive queries are the other way to do this ...
44016 Oct 2008 @ 09:16 PDTDatabaseReply"DBS CRASHED OR SESSIONS RESET." error when using bteq on Solarisif there's teradata odbc installed in your system, try making use of the adhoc program in the examples folder to connect.The other issue I could think of is a firewall problem between the two syste...
43915 Oct 2008 @ 05:35 PDTDatabaseReplywhat are macros in teradataTo give a brief intro ..macros are a bunch of SQLs bundled together , provides transactional integrity (all the sqls in the bundled is considered as part of a single transaction), convenience (you ...
43815 Oct 2008 @ 05:12 PDTDatabaseReply"DBS CRASHED OR SESSIONS RESET." error when using bteq on Solariscan you try login using ip address from bteq ?.logon v.x.y.z/id;Also compare the ip address you get via ping / nslookup to the actual IP address ( are they same)
43714 Oct 2008 @ 04:19 PDTUDAReplyNeed the distinct month dateIf you are trying to get the month portion in the query, you can do this.SELECT EXTRACT(MONTH FROM DTE)FROM myTable
43614 Oct 2008 @ 11:00 PDTToolsReplyResult from BTEQ to be loaded in a tablewhy do you want to first dump the o/p of the result set to a log and then load it back to a result table ... ?you can always modify the bteq to insert directly into a result table.INSERT INTO SELE...
43513 Oct 2008 @ 10:15 PDTUDAReplyIdentifying Table Creatorlook for creatorname in dbc.tables view
43413 Oct 2008 @ 10:13 PDTAnalyticsReplyReducing runtime for a MLOAD jobJust to experiment, can you try concatenating all the files and do a fastload to an empty table ?Also is your 26 million the number of records you are loading or the number of records in the table ...
43313 Oct 2008 @ 10:07 PDTToolsReplyFlat file with delimiters in FastExportif your purpose is to fastexport from one table and mload else where, why don't you make use of the mlscript option of fastexport ?
43212 Oct 2008 @ 09:33 PDTDatabaseReplyService not starting for 12.0 DBDo a pdestate -a and you will know for sure whether your DB is up or not.
43110 Oct 2008 @ 10:23 PDTAnalyticsReplyReducing runtime for a MLOAD jobvery little information to give useful comments...But these would be the direction on which I would investigateWhat is the number of records on the table ? is it partitioned ? on what ? how many re...

Pages