9 More Discussions You Might Find Interesting
1. 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
2. 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
3. Windows & DOS: Issues & Discussions
Hi
Can we pass the parameter from the excel in windows and invoke the unix shell script from excel VBA by passing this parameter and get the results of shell script to the excel sheet?
We tried to get the things in unix independently but we still strucked in connecting the excel to... (5 Replies)
Discussion started by: bikky6
5 Replies
4. Shell Programming and Scripting
Helo Experts,
I have an issue in connecting to sybase from UNIX.
PFB, my code :
#!/bin/ksh
###############################################################################
#
# Filename: docflo_split.sh
#
# Description:docflo_split.sh WrapperScript splits the temporary file... (1 Reply)
Discussion started by: Nits
1 Replies
5. Shell Programming and Scripting
Hi All,
I am trying to export a file using Fast Export (Teradata) in UNIX. The desired output length is 550 bytes, but the output file is creating string till 75 characters. How to get the full length file?
.LOGON
.EXPORT file=export.txt;
SELECT CAST(('' ||
(CAST('UD ' AS CHAR(3))) || ... (2 Replies)
Discussion started by: unankix
2 Replies
6. Shell Programming and Scripting
Hi,
I am trying to connect to the database through Unix serer using following command-
mysql -u root -Jepadt -D dtdatabase
But it giving me error -
mysql: unknown option '-J'
Can anybody help me to solve this problm
Thanks in advance
Please use code tags, thanks. (2 Replies)
Discussion started by: pspriyanka
2 Replies
7. Programming
I am trying execute a sql file from the script and the sql file has the following code snippet, which throws out the error given below
FOR C_FINELINE_LP AS CURSOR C_SLS FOR
SELECT * FROM WM_UTIL.FLT_DEP
WHERE LOAD_IND = 'N'
DO
.....
.....
....
END FOR;
FOR C_FLTSLS_STR_LP AS... (0 Replies)
Discussion started by: yschd
0 Replies
8. 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
9. Shell Programming and Scripting
Hi,
Is there any method to connect unix box(Excecuting unix commands through Batch Files) through DOS prompt. (1 Reply)
Discussion started by: shekhar_ssm
1 Replies
