RE: at - Job with Windows NT

Run a shell script with the at command and set the environment variables at the start of the shell script. Then let the shell script call whatever you want top run and it will pass the environment variables on. > Hi, > > we have a program (wriiten in Delphi) that uses Informix > ODBC 3.31. It has to run each night. > It reads rows from one database, converts them und puts them > to another database. > (IDS 7.31 and IDS2000) > > Starting it as user XXX all works fine. > > Starting it from an "at - job", we get trouble with the DATE-format. > > I suppose with the "at - job" the settings of setnet.exe are > not be known to > the Informix ODBC 3.31 driver. > > I tried the following: > - Defining a setnet environment for nt-user administrator > - set DBDATE=DMY4. in the batch program which calls the > convert programm > - set DBDATE=DMY4. in nt system environment > > All this doesn't help, we always get the error message that > month doesn't match. > > How can we tell the "at - job" the informix environment we need? > > If anybody has an idea please tell me. > > TIA > Reinhard ___________________________________________________________________________ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of Sema Group. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the Sema Group Helpdesk by telephone on +44 (0) 121 627 5600. ___________________________________________________________________________

COOPER, Joseph <Joseph.COOPER@sema.co.uk> schrieb in im Newsbeitrag: 8bvbd6$9i6$1@news.xmission.com... > > Run a shell script with the at command and set the environment variables at > the start of the shell script. Then let the shell script call whatever you > want top run and it will pass the environment variables on. Sorry, but that does not work as I mentioned in my initial question. With Unix that works but not with Windows NT. I tried the following: rem start.bat: set DBDATE=DMY4.myconvert.exe rem End Any other ideas? > > Hi, > > > > we have a program (wriiten in Delphi) that uses Informix > > ODBC 3.31. It has to run each night. > > It reads rows from one database, converts them und puts them > > to another database. > > (IDS 7.31 and IDS2000) > > > > Starting it as user XXX all works fine. > > > > Starting it from an "at - job", we get trouble with the DATE-format. > > > > I suppose with the "at - job" the settings of setnet.exe are > > not be known to > > the Informix ODBC 3.31 driver. > > > > I tried the following: > > - Defining a setnet environment for nt-user administrator > > - set DBDATE=DMY4. in the batch program which calls the > > convert programm > > - set DBDATE=DMY4. in nt system environment > > > > All this doesn't help, we always get the error message that > > month doesn't match. > > > > How can we tell the "at - job" the informix environment we need? > > > > If anybody has an idea please tell me. > > > > TIA > > Reinhard > > ___________________________________________________________________________ > This email is confidential and intended solely for the use of the > individual to whom it is addressed. Any views or opinions presented are > solely those of the author and do not necessarily represent those of > Sema Group. > If you are not the intended recipient, be advised that you have received this > email in error and that any use, dissemination, forwarding, printing, or > copying of this email is strictly prohibited. > > If you have received this email in error please notify the Sema Group > Helpdesk by telephone on +44 (0) 121 627 5600. > ___________________________________________________________________________ >