405 | 23 May 2008 @ 01:31 PDT | Database | Reply | To capture the return code in BTEQ | AFAIK, errorcodes work with only the actual database errors (like table not found etc), not with bteq errors itself (like file not found...)... but then you can check if the file exists or not in a... |
404 | 23 May 2008 @ 01:15 PDT | Database | Reply | Concatenation Of two Strings....... | And you can't run a select statement from dynamic sql call... you can however declare a dynamic sql cursor if your are on TD12 |
403 | 19 May 2008 @ 10:47 PDT | Tools | Reply | a simple question about IDENTITY | generated by always means teradata will insert a value of it's own even if you explicitly specified a value for the identity column in your insert.generated by default on the other hand will genera... |
402 | 17 May 2008 @ 03:00 PDT | Database | Reply | To capture the return code in BTEQ | you may want to look up the errorcode and errorlevel variables in bteq manual and explore the ways in which you can use it with the .IF control construct in bteq to accomplish what you want. |
401 | 08 May 2008 @ 02:01 PDT | Database | Reply | Teradata Recursive SQL | I haven't tested... but something like this should work ...WITH RECURSIVE RECTBL(CHLD, PRNT, LVL)AS( SELECT CHILD, PARENT, 1(INTEGER) FROM MYTBL WHERE CHILD = 'G' UNION ALL SELECT MYTBL.CHILD,... |
400 | 02 May 2008 @ 08:56 PDT | Database | Reply | Recursive view | It kind of didn't turn out to be as easy as I thought, but neverthless here's one way... ( The objective was to get all the emps that comes under steve to be pulled out into a view along with their... |
399 | 30 Apr 2008 @ 01:39 PDT | Database | Reply | Recursive view | Is there any reason why you can't define this final view itself as a recursive view ? (The final select in the recursive definition can actually be joined with other tables and filter conditions ad... |
398 | 24 Apr 2008 @ 09:15 PDT | Database | Reply | Backup/Recovery of DBQL | PMCP is normally a onetime setup kind of thing which you would have to purchase from teradata (I think it's sort of done by the PS guys)... and it's kind of "the" standard practice these days...how... |
397 | 23 Apr 2008 @ 12:11 PDT | Database | Reply | Backup/Recovery of DBQL | Have you considered getting the PMCP package from Teradata ? |
396 | 22 Apr 2008 @ 01:36 PDT | Database | Reply | Teradata equivalent with recursive | I think what you are looking for is something like this ....WITH RECURSIVE RECEMP(EMP_ID, EMP_DB, LEVEL)AS( SELECT EMP_ID, EMP_DB, 1(INTEGER) FROM EMP WHERE EMP_ID = 11 UNION ALL SELECT E.EMP_... |
395 | 19 Apr 2008 @ 02:56 PDT | Database | Reply | Masking commas within a macro parameter | you cannot have INTO clauses in macros, they can be used in stored procs. how ever, you can't have recursion in stored procs...here's my suggestion ...Replace MACRO database.get_data(Opco_code VARC... |
394 | 17 Apr 2008 @ 11:43 PDT | Tools | Reply | Fast Export Script Syntax | .export outfile C:\Fast_data.txt mlscript C:\Mload.txt format text ; |
393 | 17 Apr 2008 @ 11:05 PDT | Database | Reply | Masking commas within a macro parameter | A recursive sql is incomplete with out a selectsoyour recursive query should be likeWITH RECURSIVE MYRECTBL(a, b, c)(........)SELECT a, b, x, y FROM MYRECTBL JOIN ANOTHERTBLON a = x;in your macro, ... |
392 | 17 Apr 2008 @ 10:52 PDT | Database | Reply | ARCHIVE - COPY STATEMENT | I was able to restore using that syntax, ofcourse it would put back only that data that it found in the archive. |
391 | 15 Apr 2008 @ 10:05 PDT | Database | Reply | ARCHIVE - COPY STATEMENT | COPY data table (target.tbl_new)(FROM (srcdb.tbl)),RELEASE LOCK,FILE = partdata; |
390 | 15 Apr 2008 @ 09:25 PDT | Tools | Reply | Fast Export Script Syntax | Control is not a keyword, you can give any name there ... it's purpose is to define the input file format from which fastexport can read some information (like the conditional filter values that ne... |
389 | 15 Apr 2008 @ 09:17 PDT | Database | Reply | Masking commas within a macro parameter | That's going to be extruciatingly painful, perhaps with the help of a bunch of GT tables and all that recursive stuff,we must be able to achieve it...But what could be a practical use for it ? |
388 | 15 Apr 2008 @ 09:11 PDT | Tools | Reply | configuration of PSA in demo CD | try using DemoTDAT for the DBS name |
387 | 15 Apr 2008 @ 09:08 PDT | Connectivity | Reply | jdbc - Invalid date supplied | That format is what we call a time stamp in teradata... this is different from a date data type.And as far I could remember the date object that you supply to jdbc should be a java.sql.Date object ... |
386 | 14 Apr 2008 @ 10:26 PDT | Database | Reply | dynamic count(*) | The other not so popular workaround is to create a dummy proc under user A which takes a character string as argument and executes it using dynamic sql... and to give execute permission on this pro... |
385 | 14 Apr 2008 @ 10:23 PDT | Analytics | Reply | How to Split Output file using SQL? | If you can use unix, there's the split command up to the task ... |
384 | 07 Apr 2008 @ 01:36 PDT | Database | Reply | Masking commas within a macro parameter | You must be able to make use of the same code, the only change I foresee is to change the cast (INTEGER) with (VARCHAR(30)) or something appropriate.and you can execute the macroexec macroname('val... |
383 | 07 Apr 2008 @ 01:20 PDT | Tools | Reply | Conditinal Logic with dynamic parameteres in BTEQ. | since you just have a 0 or 1 check, you can re-write the query logic to return 0 or >0 rows and make use of the bteq variable ACTIVITYCOUNT along with bteq's if then control language to accompli... |
382 | 18 Mar 2008 @ 01:34 PDT | Tools | Reply | why FastExport never works for me? | I am wondering if you are mixing up between bteq and fast export.... they are two different utilities... you invoke the fast export utility via the executable fexp I suggest you to go through some ... |
381 | 18 Mar 2008 @ 01:31 PDT | Analytics | Reply | Code help needed to summarise table | What I don't understand is, just by looking at the data how can I say that call which started at 08:21:32 ended at 08:23:35 and not at 13:02:17 ? (I know some folks who can talk that long :o ) |