Error: SQL3100W while export in DB2

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX with DB2 error status Issue

I have a shell script main.ksh We are calling dbscript.ksh from main.ksh I am using select statement in dbscript.ksh but there is a problem with the select statement in dbscript.ksh but still echo $? is showing as zero. I am using DB2 commands in dbscript.ksh Main.ksh dbscript.ksh echo $? ...

2. Homework & Coursework Questions

DB2 Export and Import Oracle

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: is this enough to make the data perfect export into delimited file? there are some posted that i read, they...

3. Homework & Coursework Questions

DB2 Export and Import Oracle

Hi Guys, I Just wanted your opinion/ suggestion/ Help on my unix script about db2 export data with deli file and import into oracle. db2 connect to Tablename user id using psswrd db2 "EXPORT TO '/cardpro/brac/v5/dev/dat/AAAAA.DEL' OF DEL select * FROM AAAAA" db2 "EXPORT TO...

4. Solaris

Zpool import/export error

A backup/clone script of ours was recently ran. It normally only clones the rpool and renames in rpoolA. Something must've changed as it found another one of our pools that it shouldn't have. It exported that pool unbeknownst to us. Later on when a coworker realized the other pool was missing he...

5. Shell Programming and Scripting

Weird Perl error using db2.

I have having a heck of a time figuring this out so any help is much appreciated. Here is the code where it seems to be dying, I bolded the part it is complaining about: $sth = $dbh->prepare( $query ) or die "error with query\n"; $sth->execute() or die "error executing query ...\n"; while(...

6. Shell Programming and Scripting

Export Error in Shell script

All, While executing the bellow commnad after the sed, awk command to export the value to, i am getting the fallowing error. line="_AABBB.EEEEEEE.LOG4JDISPLAY.PATH_=/apps/opt/abcde/pdstdsd/esapp/apadsfasdf/logadsfasdf.xml" keystring=`echo $line | awk -F"=" '{ print $1 }'`...

7. Shell Programming and Scripting

Run DB2 export command in loop

Hi All, I have list of 100 table names in a file, how to read table name from and pass to DB2 export command and run for all tables in loop. Please help me with script. db2 EXPORT TO ~/data_export/<table name from file>.ixf OF IXF MESSAGES messages.txt "SELECT * FROM ITG.<Table Name...

8. Shell Programming and Scripting

Export data from DB2 table to .txt file(space delimited)

Hi I need help on this. Its very urgent for me.. please try to help me out.. I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export...

9. Shell Programming and Scripting

error while using export command

Hi All, In my script i am using data from oracle table for validation. #!/bin/sh export UID=dun_ind export PWD=`getID dun_ind` fed_ctrl=`sqlplus -s $UID/$PWD@lms <<END set feedback off; set heading off; select sta from controls where sta = 'ABC'; EXIT; END` echo $fed_ctrl...

10. UNIX for Dummies Questions & Answers

Exception while loading DB2 driver Class.forName("com.ibm.db2.jcc.DB2Driver")

Hi... I m working on UNIX z/OS. Actually i have to pass the parameters from the JCL to java-db2 program thru PARM. I am able to pass the arguments but the problem occured is, it is throwing an exception while loading the db2 driver as 'Javaclassnotfound:com.ibm.db2.jcc.DB2Driver'...

LEARN ABOUT SUNOS

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)

Shell Programming and Scripting