#DateForumTypeThreadPost
19129 Feb 2012 @ 03:13 PSTToolsReplyError when executing a Fastload script **** 09:56:31 FDL4802 Already logged on this seems to be odd. Can you share the script and the whole log?
19029 Feb 2012 @ 01:26 PSTDatabaseReplyCompare strings in bteq statement, not in sql You might use the following select 'OK' from sys_calendar.calendar where calendar_date = current_date and 'tst' = '${JOB_ENV}'; .if Activitycount = 1 then .goto C...
18929 Feb 2012 @ 01:20 PSTDatabaseReplyCompare strings in bteq statement, not in sql Will not work this way. According to the BTEQ manual (see attached jpg) .if is limited to conditions on ERRORCODE, ERRORLEVL and ACTIVITYCOUNT. So you can't compare strings as you li...
18828 Feb 2012 @ 11:42 PSTGeneralReply3760:String not terminated before end of text I don't see the issue here right now. Usually I don't specify the ' ' in the Trim as this is the default. So TRIM(BOTH from maxval) should be Ok. But the syntax seems nev...
18728 Feb 2012 @ 12:10 PSTDatabaseReplytranslate join on two conditions to a select statement select * from B qualify end_date = max(end_dt) over () should do. but check also select * from b where  (select max(end_date) from b) = end_date depend on your data which wi...
18628 Feb 2012 @ 11:49 PSTDatabaseReplyDatabase Space Concerns http://forums.teradata.com/forum/tools/code-2644-no-more-room-in-database might also give some hints.
18528 Feb 2012 @ 11:46 PSTDatabaseReplyDatabase Space Concerns Did you specify the primary index? If not the first column is used by default. Most likely that there is a skew issue. If not check that the existsing tables in this database doesn't...
18428 Feb 2012 @ 10:41 PSTDatabaseReplytranslate join on two conditions to a select statement do you really mean RANK? Are you aware that RANK can result in many rows per value? Also this would give all records for the biggest end_dt. So you might need to consider to add a partition ...
18328 Feb 2012 @ 09:01 PSTGeneralReply3760:String not terminated before end of text And I it seems to be a correct one - so you can run this? The first ' of  'metadata'  has a different color - but I guess this doesn't mean it is a different `or &a...
18228 Feb 2012 @ 08:00 PSTGeneralReply3760:String not terminated before end of text The error message means that a string is not terminated - which means a string starts with an ' but not second ' can be found. Do you have a SP debug or log table where the SP can in...
18128 Feb 2012 @ 04:42 PSTGeneralReplyHow to calculate query cost and compare 2 queries which gives the same result set?     Won't argue against your statement on elapsed time in general Where it becomes an issue is if elapsed time is the one where SLAs are defined on. Tactical queries ca...
18028 Feb 2012 @ 12:07 PSTPrivate Forum
17927 Feb 2012 @ 11:29 PSTDatabaseReplydelete xxx rows with teradata Hi Dieter, juup, I missed this bit in your query :-). And Top is working there as well. Thanks Ulrich
17827 Feb 2012 @ 10:53 PSTDatabaseReplydelete xxx rows with teradata Top N is not allowed in derived queries. So the only way to emulate the Sybase syntax would be dieters example.
17727 Feb 2012 @ 10:29 PSTDatabaseReplydelete xxx rows with teradata There exists nothing like this teradata (delete xxx rows). You need to find a where condition which specifies the rows you want to delete. delete from tableA where col1 = xx and ...
17627 Feb 2012 @ 06:46 PSTDatabaseReplymillisecond part is stripped from time(6) column Hi HP, seems to be an ODBC issue. Teradata.Net connection with SQL Assitent 13.11 gives   a                       &nbs...
17526 Feb 2012 @ 12:51 PSTDatabaseReplymillisecond part is stripped from time(6) column yes, seems to be an interface problem. its interessting that timestamp and time is giving different results in respect to the millisec. Also try .net connection, maybe this show them correctly -...
17425 Feb 2012 @ 12:35 PSTPrivate Forum
17325 Feb 2012 @ 11:53 PSTPrivate Forum
17225 Feb 2012 @ 07:02 PSTDatabaseReplymillisecond part is stripped from time(6) column current_time(6) (and current_timestamp(6)) will have only 2 significant digits - see documentation... if you import data with 6 digits it should work - see log below... BTEQ 13.10.00.01 S...
17125 Feb 2012 @ 01:02 PSTDatabaseReplymillisecond part is stripped from time(6) column Works fine on my system - see bteq log below. How do you query the table? Try select cast(yourcolumn as varchar(30)) from yourtable to check that this is not a problem of the q...
17024 Feb 2012 @ 08:59 PSTDatabaseReplyIs this a valid insert? Sorry for the \ they are placed automaticly in my editor. Didn't saw them when I copied them. Yes, null need to be handled correctly. I had the impression from the initiial post that you...
16924 Feb 2012 @ 07:02 PSTDatabaseReplyIs this a valid insert? Which tool do you use? Which access (odbc or .net)? Which DB version? What is the exact error code?
16824 Feb 2012 @ 06:28 PSTDatabaseReplyIs this a valid insert? can you run my bteq script (with all conditions) and share the bteq output?
16724 Feb 2012 @ 05:29 PSTDatabaseReplyIs this a valid insert? hm, this is my bteq output - looks fine to me. BTEQ 13.10.00.01 Fri Feb 24 14:27:50 2012 +---------+---------+---------+---------+---------+---------+---------+---- .run file ./logon.txt...

Pages