10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I want to write a shell script which connect to my database with the following credentials :
User name : user
PWD : rap_user_1
Hostname : app.Unix.Gsm1900.Org
Port : 7862
SID : PTNC1
Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies
2. Shell Programming and Scripting
Can any one please share a unix script for validating the export of a mapping which is in XML format
Any help would be great for me.
Thanks (4 Replies)
Discussion started by: sampoorna
4 Replies
3. UNIX for Advanced & Expert Users
Hi I am working on a script in which I am firing a query on database through Unix and getting the result set. I want to export that in an excel file. I am able to do so nut the result are exported horizontally one below the other. Can anyone plss help me out in exporting the Result in Tabular... (4 Replies)
Discussion started by: Saritau3
4 Replies
4. 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
5. Shell Programming and Scripting
Hi,
executing below command for export in cygwin, though I have already mentioned the username and password with the command but on execution it again asks for username, what modification is needed in the below command ? may be there is some problem in using inverted comma ?
exp... (1 Reply)
Discussion started by: milink
1 Replies
6. UNIX for Dummies Questions & Answers
/opt/teradata/client/bin/fexp <<EOP
.LOGTABLE load_work.datastore_log1 ;
.LOGON BOX/userid,password;
.BEGIN EXPORT
SESSIONS 20;
.EXPORT OUTFILE $path MODE RECORD FORMAT TEXT;
select
trim(cast(PROC_YYMM_DT as char(5))) (title ''),
cast('~' as char(1)),
trim(cast(ACCNO as char(21)))... (1 Reply)
Discussion started by: depakjan
1 Replies
7. Shell Programming and Scripting
Hi,
Can any one share a unix script for validating the export of a mapping which is in XML format.
like my requirment is that when ever we are migrating the mappings or wokflows from development to QA we will take the export of that mapping into an XML file.Insted of reviewing the mapping... (1 Reply)
Discussion started by: perlamohan
1 Replies
8. UNIX for Advanced & Expert Users
Hi,
Can any one share a unix script for validating the export of a mapping which is in XML format.
like my requirment is that when ever we are migrating the mappings or wokflows from development to QA we will take the export of that mapping into an XML file.Insted of reviewing the mapping... (1 Reply)
Discussion started by: perlamohan
1 Replies
9. UNIX for Advanced & Expert Users
Hello,
I have 2 or more environment files, with identical variable names; see below:
.env_file1
export PROJNAME="XYZ"
export PROJID="2"
.env_file2
export PROJNAME="WSX"
export PROJID="9"
.env_file(n)
export PROJNAME="QAZ"
export PROJID="12"
The env files above will be sourced... (2 Replies)
Discussion started by: Nomaad
2 Replies
10. UNIX for Dummies Questions & Answers
Hi,
I am searching a way to export data file on Unix to SQL server on a daily bases.
Any one has any ideas?
Thanks in advance! (20 Replies)
Discussion started by: whatisthis
20 Replies