I wonder which scripting language you are using for scripting both
Windows and AIX.

- Write everything twice, once for bash, once for DOS batch?
- Use a stored procedure
- Use the java that comes with every DB2 installation
- Install bash/perl/your-favorite-scripting-language
- ...

Currently I'm using the first variant, but I don't know which is more
limited, my knowledge of DOS batch or DOS batch itself...

On Oct 18, 12:29*pm, Willem Fischer <w.l.fisc... (AT) googlemail (DOT) com>
wrote:
Did you checkout Cygwin? That might help you with the double work.

--
Frederik Engelen

On Oct 18, 5:29*am, Willem Fischer <w.l.fisc... (AT) googlemail (DOT) com> wrote:

For windows, I use cygwin for the Shell environment and you may need a
little effort to configure the cygwin shell to work well with DB2.

I highly opt to believe that cygwin+Perl will be the best choice for
this condition.

On 18.10.2010 12:29, Willem Fischer wrote:
Unix-Environments. It is a great Language.
I also take a look at REXX. It is available for Windows and Unix
and for a lot of other Operating-Systems.

On Oct 18, 3:29*am, Willem Fischer <w.l.fisc... (AT) googlemail (DOT) com> wrote:
I usually go with perl, but this can be problematic on UNIX
environments if you don't have a C compiler and/or root privileges
(assuming you want DBI + DBD:B2).

Java is an OK (but heavy) option for scripting; but there are also
limitations in what you can do (you'll become dependent on
SYSPROC.ADMIN_CMD very quickly).

DOS (cmd.exe) is a joke for scripting. I've heard of people starting
to use PowerShell, but don't have any experience in it.

On 2010-10-18 12:29, Willem Fischer wrote:
As others have mentioned, Cygwin is a one way to avoid DOS (the best way
is of course to get rid of Windows ;-) . When it comes to more
complicated scripts, my preferred language is Python.


/Lennart

Usually I write all my scripts in ksh or bash, since I don't use any Windows
boxes.
If a script _has_ to run on AIX and Windows, I usually go with perl or php.

cygwin is also an option, but most customers have rather perl than cygwin
installed on their Windows machines.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On Oct 18, 4:29*pm, Hardy <wyh... (AT) gmail (DOT) com> wrote:
I had no problem working with cygwin and DB2 V8 on my personal
machine. Since DB2 9 the connections are not held in cygwin sessions.
Did you find a way around that?

Willem Fischer <w.l.fischer (AT) googlemail (DOT) com> writes:

If you need portable code, I'd also recommend becoming proficient in
Perl. Search for Perl DBI, here is one article as a reference:

http://www.ibm.com/developerworks/da...512greenstein/

Regards,
--
Haider