#DateForumTypeThreadPost
810 Sep 2012 @ 06:22 PDTToolsReplyBTEQ REPORT @anjanpaul: I've tried these included but my purpose is not served.   .SET FORMAT OFF;  --i'm already using this.  Sorry that I missed to mention.   ...
706 Sep 2012 @ 12:26 PDTToolsTopicBTEQ REPORT Hi, I'm using the following code to create a report. <LOGON COMMAND> .EXPORT REPORT FILE=MY_FILE.TXT SELECT COLUMN1,COLUMN2,COUNT(*) FROM MY_TABLE; <LOGOFF COMMA...
610 Aug 2012 @ 06:35 PDTToolsTopicTPT - LOAD_OPERATOR - Issue Hi, I'm using a TPT with LOAD_OPERATOR to load a flat file (Format='Text') into an empty table.  I'm receiving the following error: LOAD_OPERATOR: connecting session...
504 Jul 2012 @ 10:56 PDTDatabaseReplyExplicit Casting @Carlos, Dieter: Thank you very much!! Your explanations helped me a lot. :)
421 Jun 2012 @ 03:06 PDTDatabaseTopicExplicit Casting Hi, I tried the following two queries. SELECT CAST(1111 AS CHAR(4)); SELECT 1111 (CHAR(4)); Though both these queries use explicit casting, former is ANSI compliant whereas the l...
321 Jun 2012 @ 12:51 PDTDatabaseTopicDATE conversion Hi, I need to convert date, which is in the format 'MM/DD/YYYY', to the target format 'DD-MMM-YY'. I tried the following query and it worked too. SELECT UPPER(CAST(CAST(C...
221 Jun 2012 @ 12:20 PDTToolsReplyBTEQ - Row Level COMMIT Thanks Jim.  This is something which I was not aware of.  Does the error table receive actual data in case of any data error? If yes, then I see a possibil...
120 Jun 2012 @ 01:16 PDTToolsTopicBTEQ - Row Level COMMIT Hi all, I've a requirement where I'm using BTEQ to move a copy of data from Table A to Table B.  I'm using a simple INSERT INTO Table B SELECT * FROM Table A; Note: ...