|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
export in unix
Post 302682029 by mprakasheee on Sunday 5th of August 2012 10:47:30 AM
08-05-2012
|
|
10 More Discussions You Might Find Interesting
1. 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
2. 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
3. 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
4. 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
5. 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
6. 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
7. 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
8. 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
9. 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
10. 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
LEARN ABOUT SUNOS
asadmin-export
asadmin-export(1AS) User Commands asadmin-export(1AS) NAME
asadmin-export, export - marks a variable name for automatic export to the environment of subsequent commands in multimode SYNOPSIS
export [ name=value [ name=value]*] Marks a variable name for automatic export to the environment of subsequent commands. All subsequent commands use the variable name values as specified; unless you unset them or exit multimode. If only the variable name is specified, the current value of that variable name is displayed. If the export command is used without any arguments, a list of all the exported variables and their values is displayed. Exported shell environment variables set prior to invoking the asadmin utility are imported automatically and set as exported variables within asadmin. Unexported environment variables cannot be read by the asadmin utility. OPERANDS
name=value variable name and value for automatic export to the environment to be used by subsequent commands. Example 1: Using export to list the environment variables asadmin> export AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=password asadmin> export AS_ADMIN_PREFIX=server1.jms-service asadmin> export //to list the environment variables that are set AS_ADMIN_HOST=bluestar AS_ADMIN_PORT=8000 AS_ADMIN_USER=admin AS_ADMIN_PASSWORD=******** AS_ADMIN_PREFIX=server1.jms-service Where: the export command lists the environment variables that are set. In this case, the environment variables have been set to: the host is bluestar, the port is 8000, the administrator user is admin with an associated password, and the prefix is server1.jms-service. EXIT STATUS
0 command executed successfully 1 error in executing the command asadmin-unset(1AS), asadmin-multimode(1AS) J2EE 1.4 SDK March 2004 asadmin-export(1AS)