Search results for query: *

I have a query it goes something like the following: Select 'test folder' select * from table. The result set will be like the following: 1 test folder 1 record1 2 record2 3 record3 4 record4 I then need to use a third party product called goanywhere to write the results to a spreadsheet...

I have a form with a button that runs a macro that runs a parameter query with a begin date and end date. Is there any way to capture those values so I can use them in the name of the report I.E. report_startdate_enddate? Cretin

I am trying to read a table in access2013 and export it to a spreadsheet in excel2013. I am actually naming the spreadsheet using a value in one of the tables fields. It works well except when I try to open the spreadsheet it gives me the error: "excel cannot open the file...

Hey, I am creating an access database to automate project hours metrics reporting. I want it as fully automated as I can so the manager just clicks buttons. . Is what we do is import excel spreadsheets into the database then run queries on them to generate reports. The issue I have is the last...

We had to set up new database server and because of such we upgraded from Oracle 10 to 11. We are running some code and receive the following messages ORA-29260 Merwork error: TNS: connection closed ORA0-6512 at "SYS.UTil_TCP", line 201 ORA-06512 at "SYS.UTil_TCP", line 346 ORA-06512 at...

This could actually be either here or windows. Our company has been recently bought out. One of our tasks was to clone some servers we were using in our old domain and add them to a new domain. For the sake of an example we will say the old domain was olddomain.net and we are moving to the...

I am not a developer I am a job scheduler. We are currently migrating jobs from OEM scheduler to Robot. We have some jobs that require parameters. How do I send parameters specifically default parameters. In grid the codee is . /home/user/run_script.ksh jobname database.schema jobname [],[],[R]...

Hey we are running 3 instances of WINSCP at the same time. We run them using OEM (Grid scheduler) as the scheduling agent to run DOS .bat programs that invoke WINSCP to transfer files using SFTP. We recently upgraded to version 5.5.3 from 4.2.9 due to intermittant transfer failures. However when...

I put this here because I was not sure where else to put it. We have an issue with VSAM. We are running on VSE/ESA. We have some files that are not defined as big enough. The code we are using is as follows: * DELETE PROD.CYCLE1.RECORDS // EXEC IDCAMS,SIZE=AUTO...

Is it possible to pass the chr function with the ascii value of % in a grid task command. Grid considers it a wildcard. Cretin

I have been tasked to writing a .bat file so a scheduler can run oracle jobs. is what i need to do is use the scheduler to send values to variables in a .bat [MM][DD][YYYY] 10 20 echo %1 %2 %3 %4 > D:\Operations\TEST\test_bats\test_log.txt now by default .bat variables that are not assigned...

Hey I need to transfer a file from a windows box to LINUX using WINSCP in a .bat. The issue is `if there is a problem when automating the script the job will hang. There is an option batch abort fommand but is not working. C: cd \Program Files\winSCP option batch abortset user=user Set...

Is there a way in PL/SQL to display a count of how many rows in a particular column has a certain length minus leading blanks? For example how many rows have a customer number less than 9 characters ignoring leading blanks. Cretin

We have some .exe files that reside on a windows box. We would like to automate them. There is one problem, they need input parameters. my task is to write DOS programs to do it. Now before you tell me that there are other scripts we should do that with i agree and suggested that to the powers...

We would like to get a text message when a job fails. Is what we did is in Outlook 2007 we set up a rule so if the word failure shows in the subject line a rule will fire to forward the message to a distribution group notify@vtext.com. The distribution group is hidden. When the e-mail comes...

I am using access 2007 for a change management database. It has been used since 2007. I would like to do an annual report with the count for each year to display on the report. I tried the sum(abs) and count to no avail. I am putting parameters in so for one count it will get me anything...

I am putting a hyperlink in an access table. When creating a report from that table is it possible to have the hyperlink clickable and even possibly stay that way after being converted to a PDF? Cretin

we are running Oracle Linux 5.2 on platform x86_64. We are running Linux natively on the hardware. We have 2 Oracle grid servers. Grid1 is the production server and gridDR is the disaster recovery server. Grid1 constantly sends archive logs to GridDr. At some point GridDR lost SSH...

I loaded oracle XE in a virtual box with a linux os. I will want to in stall APEX into that. I am now trying to call sqlplus and get the following message: sp1<lang>.msb not found error 6 initializing sqlplus message file .msb not found sp2-0750 you may need to set Oracle_home to your oracle...

I am trying to set up Oracle ASM in a virtual box. The Oracle is 11G Release 1. I need to run runInstaller(./runInstaller) to create an ASM instance. I am signed on as Oracle but Linux can't find it, any idea how I can find or get it? Cretin