9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi Team,
I have a requirement where I need to check for table. If exists, drop it else do nothing. For that I written below code.
T_NAME="V_"`echo ${PARAM_BASE} | cut -d'_' -f4-`
tab_name="UV_"${T_NAME}
query_et()
{
bteq << EOBTQ | grep '^>' | sed -e "s/^>//"
... (11 Replies)
Discussion started by: ace_friends22
11 Replies
2. Shell Programming and Scripting
Hi All,
I need to write Unix shell script. To star with : I need to do some file checking on unix file system, then based on file existance, I need to run diff SQL in Teradata Bteq. After that, depending on Results of SQL, I need to code other shell scripting like moving file, within same... (4 Replies)
Discussion started by: Shilpi Gupta
4 Replies
3. UNIX and Linux Applications
Has anyone used either bteq or mload for inserting into a Teradata Database via perl. We're running Red Hat Enterprise 5.7. I've gotten the DBD::ODBC drivers installed and running. I installed the Teradata ICU, TeraGSS and ODBC pkgs. We are using perl to insert data across the network into... (1 Reply)
Discussion started by: islanderman
1 Replies
4. Shell Programming and Scripting
I am using below code to connect terdata and getting the query result in a file.Now i want to use same code for different tables,plz tell me how to pass table name as parameter.i tried using as below code but not working.
bteq < /download/viv/dev/ops/Scripts/ter.sh FLTORGTKR_ORG_etc..
... (1 Reply)
Discussion started by: katakamvivek
1 Replies
5. Shell Programming and Scripting
Hi,
I want a script for connecting teradata to load the file to teradata table.
Can you please help me out.
Thanks in advance. (1 Reply)
Discussion started by: victory
1 Replies
6. IP Networking
Hi
Can any one please help identify the issue in scenario 2:
Connectivity Diagram:
1) Distribution Switch----Int_Switch----LabSwitch(Fa1/0)----Terminal Ser
2) Distribution Swtich----Int_Swtich----LabSwitch(Fa2/0)----3640 Router
---all links are access links
Distribution Switch... (0 Replies)
Discussion started by: sureshcisco
0 Replies
7. IP Networking
How to check connectivity with an external server if I know the IP.
Please note traceroute is not working for me, as it is saying command not found. (6 Replies)
Discussion started by: nixhead
6 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I am trying to run some SQL scripts under the UNIX server using BTEQ. When I try to create a log file, the file gets populated only to the point where I log into BTEQ.
The log file for the running of the actual script does not seem to be stored.
Would any one know ehy this could be... (3 Replies)
Discussion started by: zsrinathz
3 Replies
9. Shell Programming and Scripting
Dear all,
can any body help me about database connectivity?
i want to data by extracting from oracle...
so please give me some idea...
Thanks,
Regards,
Pankaj (1 Reply)
Discussion started by: panknil
1 Replies