#DateForumTypeThreadPost
3602 Oct 2014 @ 01:00 PDTGeneralTopicchecking for invalid or junk or special characters on numeric fieldHi All,   i am trying to find out the Invalid characters (Junk/special characters) on the numeric column it's data type is BIGINT AND (DBC.ABC LIKE '%&%' OR DBC.ABC L...
3514 Sep 2014 @ 07:18 PDTGeneralReplyImporting data in data mode is failing in BTEQQuick check on one thing. if a record is rejected where can we redirect the rejected record ,will that be possible for us to incorporate a logic in the BTEQ script???    
3413 Sep 2014 @ 12:08 PDTGeneralReplyImporting data in data mode is failing in BTEQi feel each error i performed i learnt something which i can keep this in mind to avoid in future...
3313 Sep 2014 @ 12:07 PDTGeneralReplyImporting data in data mode is failing in BTEQThanks Dieter...script ran filne data loaded i am performing lot of mistakes...i know these are Elimentary level errors...thanks a lot for correcting/guiding..   Sucess Result C:\Users...
3213 Sep 2014 @ 11:45 PDTGeneralReplyImporting data in data mode is failing in BTEQHi All, i did tried to correct the errors ,however i was not able to figure out the issues...     C:\Users\rgopidi>BTEQ    Teradata BTEQ 15.00.00.00 for WIN...
3113 Sep 2014 @ 08:04 PDTGeneralReplyImporting data in data mode is failing in BTEQok i got it now..thanks 
3013 Sep 2014 @ 06:30 PDTGeneralReplyImporting data in data mode is failing in BTEQoops i did check the issues  http://forums.teradata.com/forum/general/bteq-import-data-file-error-0 rectified the issues ,however again the script failing.....     C:\User...
2913 Sep 2014 @ 06:23 PDTGeneralReplyImporting data in data mode is failing in BTEQHi Dieter,   i have changed accordingly but now am getting this error .SET SESSION TRANSACTION ANSI .SET FORMAT ON .SET INDICDATA OFF .LOGON 127.0.0.1/dbc,dbc  DATAB...
2812 Sep 2014 @ 09:44 PDTGeneralTopicImporting data in data mode is failing in BTEQ      Hi All,   i have just started an exercise "Importing Data in Data Mode uisng BTEQ" ,however my scirpt failed ,below are the details.   Script ...
2712 Sep 2014 @ 05:07 PDTDatabaseReplyCAST and SUBSTR can be applied on the same column at a time in the same queryThanks Glass.   Raj below is the i/p and o/p just now i have ran in BTEQ. Input .OS del EXPORT_DATA_PARTY_REPORT.txt .SET SESSION TRANSACTION ANSI .SET FORMAT ON ....
2612 Sep 2014 @ 04:14 PDTDatabaseTopicCAST and SUBSTR can be applied on the same column at a time in the same queryHi All,   one of my field having unwanted characters ,below is the scenario COL1 xyzCRICKET ABXFOOTBALL DDGTENNIS i need to remove the 3 unwanted charcters ,so i have applied  SEL...
2512 Sep 2014 @ 03:55 PDTGeneralReplyOracle Data used as Input for BTEQThanks for the clarification...i get it now.
2412 Sep 2014 @ 01:40 PDTDatabaseReplyQuery IssueThanks for the input .i am learning TD only but iam using the source from oracle to pull the data using BTEQ.
2312 Sep 2014 @ 12:26 PDTGeneralTopicOracle Data used as Input for BTEQHi All, Greetings!! I have tried to run a simple BTEQ Export data using Report Mode ,my source is Oracle. i am facing an issue logging into BTEQ with Oracle credentials. Quick Checks verified ...
2212 Sep 2014 @ 12:14 PDTDatabaseReplyQuery IssueRaj,   Quick suggestion is it advisable to include Between the CASE statement and specify the range to get the desired out put?   CASE WHEN SAL BETWEEN 800 AND 1300 THEN 'L...
2112 Sep 2014 @ 12:01 PDTDatabaseReplyQuery IssueRaj, Excellent thanks for the inputs.
2011 Sep 2014 @ 01:12 PDTDatabaseTopicQuery IssueHi All,   i got stuck in between with the query.   SELECT EMPNO, ENAME, CAST(JOB ||'_'|| MGR AS VARCHAR2(50)), HIREDATE(FORMAT AS 'YYYY-MM-DD') AS JD...
1911 Sep 2014 @ 11:59 PDTGeneralReplyunable to run the Simple BTEQ scriptThanks Glass,Krish....i figured it out the issue it's the logon issue and the script issue as well    Teradata BTEQ 15.00.00.00 for WIN32. PID: 7092  Copyright 1984-2...
1811 Sep 2014 @ 11:04 PDTGeneralReplyunable to run the Simple BTEQ scriptGlass, It's still showing the same error.  
1711 Sep 2014 @ 10:14 PDTGeneralTopicunable to run the Simple BTEQ scriptHi All,   i have tried to run a simple command in BTEQWIN .SET SESSION TRANSACTION ANSI .SET FORMAT ON .SET INDICDATA OFF .LOGON 127.0.0.1/DBC,DBC database cu...
1611 Sep 2014 @ 06:36 PDTDatabaseReplyConvert string into dateHi Quick Doubt i have applied CAST for a Date field to get the data in the below format for Date field MMM-DD-YR SELECT EMPLOYEE_NUMBER,MANAGER_EMPLOYEE_NUMBER,DEPARTMENT_NUMBER,JOB_CODE,LAST...
1511 Sep 2014 @ 06:01 PDTDatabaseReplyConvert string into dateThanks Dieter.
1410 Sep 2014 @ 12:25 PDTGeneralReplyDATA TYPE FOR EMAIL ADDRESSThanks every one for your inputs. really helpful.
1309 Sep 2014 @ 02:14 PDTGeneralTopicDATA TYPE FOR EMAIL ADDRESSHi,   what will be the data type used for email address innthe table creation CREATE TABLE DBC.TABLE ( C_ID CHAR(10) NOT NULL, CNAME VARCHAR(30), JDATE DATE FORMAT 'D...
1207 Sep 2014 @ 10:28 PDTDatabaseReplyConvert string into date SELECT CAST(CAST(JDATE AS FORMAT 'MMMM-DD-YY') AS VARCHAR(15)) TRIM (CAST(JDATE AS FORMAT 'MMMM-DD-YY')) FROM USER_DBC.DUM;

Pages