10 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. Web Development
Hi,
I know how to populate a combo box or a drop down list box which I do as under :
Query that gets the data for the drop down box :
$qry = "select \"EmployeeID\" AS empid, \"FirstName\"::text || ' ' ||\"LastName\"::text as name from \"Employees\"";
$qq =... (1 Reply)
Discussion started by: terrykhatri531
1 Replies
4. 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
5. AIX
Hi all,
I ended up replacing a failed disk drive on my power 7. I had a few issues with unmirroring as it had a stale logical volume. I ended up finally getting it to unmirror the rootvg. I had an empty space in slot 3 so I ended up putting the new disk in slot 3. It configured to hdisk0 with no... (2 Replies)
Discussion started by: AlexanderIII
2 Replies
6. 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
7. 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
8. Shell Programming and Scripting
If a log file is in the following format
28-Jul-10 ::: Log message
28-Jul-10 ::: Log message
29-Jul-10 ::: Log message
30-Jul-10 ::: Log message
31-Jul-10 ::: Log message
31-Jul-10 ::: Log message
1-Aug-10 ::: Log message
1-Aug-10 ::: Log message
2-Aug-10 ::: Log message
2-Aug-10 :::... (3 Replies)
Discussion started by: vikram3.r
3 Replies
9. AIX
When and how is the variable $HOSTNAME populated ?
I am asking because I had a weird situation that just happened.
I have created backup scripts that do backups on different servers. Each servers has different folders to be backed up. So I had included a check on $HOSTNAME to find out which... (5 Replies)
Discussion started by: Browser_ice
5 Replies
10. Shell Programming and Scripting
I want to connect to bteq using Perl script and i am unaware of how to do this?
In Shell script it is very simple,
Bteq<<-END
.logon .....
...
.quit ...
END
but what is the syntex for perl?
Please help me out .
Thanks
Kunal (1 Reply)
Discussion started by: kunal_dixit
1 Replies