Search results for query: *

I have 4 batch processes that begin to run at the same time. They all read from and write to a properties file. So the properties file looks like this (with the values changing everyday, of course): Batch1Date=20040809 Batch2Date=20040729 Batch3Date=20040808 Batch4Date=20040808 These wont have...

I have a procedure that looks like this: CREATE PROCEDURE DAY0_PROC (OUT v_ts TIMESTAMP) LANGUAGE SQL P1: BEGIN .. --v_ts receives some value here END P1 I have a unix shell script that calls it like this: db2 "CALL DAY0_PROC(?)"; After this call, in the unix script, I want to capture the OUT...

I am writing a #!/bin/sh script on SunOS5.8. I want to read keyboard input and if the input timesout, I want to default to something else. I have looked in forums and found quite a few techniques none of which seem to work for me... MY script looks something like this (there is no IF condition...

my requirement: read txt file and if not empty do something. I notice that on one unix server, i use vi to create an empty file, but the file size is 1, not 0. the bottom of the vi editor says the file has '1 line, 1 character' although i did a 'dd' and made sure the file is empty. On another...

i am trying to do a simple sftp put. i want it to not prompt for password. searching on the net, i get more info about how to keep the password secure and less about out to do it the lazy-easy way cos i really am not concerned about password security right now. how do i do it with hardcoded...

i notice on forums and documentation that order of declarations in DB2 needs to be Vars, Conditions, Cursor, Handler. Added to these i have a global temp table. i have tried out several combinations. #1. For Vars, Cursor, GlobalTempTable, Handler, i get the error: An unexpected token "<handler...

my requirement: i have to generate a flat file from some simple Table1. then i need to insert into Table2 a record for every record from Table1 that was exported (Table2 is kind of a status table). so the steps would be: #1. EXPORT TO (that includes a SELECT from Table1) #2. UPDATE Table2 with...

my requirement: - i extract db2 data into flat files and send to remote - remote transforms and loads to oracle and confirms it - on confirmation of replication, i set a flag on every record of my table that says replication was successful my question: after generating the flat files, there is...