• Running Multiple SQL statements through JCL

    I need to run multiple sql statements seperatd by ';'. I want the execution to continue for all the SQL statements even if any of the SQLs throws out error. Is it possible?

    Vmfquest5 pointsBadges:
  • Adding another level of security to SQL 2005 database

    We have a SQL 2005 Database. It is protected by Windows Authentication. Can we add another level of security - requiring a SQL username and password along with a valid user name and password on the domain?

    NewnanIT1,110 pointsBadges:
  • Need project plan for Access 2007 database migration to SQL Server

    project plan with steps outlined

    Anflores5 pointsBadges:
  • Rename file in CL

    Hi all. I need to check if the file exist, and rename it. t How do I check file existing in CL? Thank you.

    Larisagas265 pointsBadges:
  • Creating Access Form

    I have a table where I want to query partial phrases or words and cannot figure out a simple way to accomplish this. I used the brackets [] in the underlying query but cannot figure out an easy way to retrieve data with partial info.

    Tbill655 pointsBadges:
  • SQL View over a table with members

    Hi all, I have an as/400 table(fileA) with several members, I need to create view that joins this to several other tables but but I need to only target one member in fileA. The other tables are all single member tables. I tried to create an alias over the table and then create the view but that is...

    Lpgast0 pointsBadges:
  • AS400 RPG – last three digits of microseconds always zero!

    We noticed in a couple of programs where we were using timestamps that the rightmost three positions are consistently zero and never otherwise. I have tested this with even just a simple ILE RPG program that dsplys a %char(%timestamp()); and still only get zeros for the last three digits....

    Koohiisan5,020 pointsBadges:
  • Recovering database files from failed Brightstor 12 server

    We have a failed brightstor 12 server. I can recover the files from the hard drive but the server is dead. We will be rebuilding a new one. Can I recover the database files and import them? And if so where are they located?

    Troubleshooter24755 pointsBadges:
  • Alter proc to fetch a table structure from SQL Server 2005 database

    hi please segest me... what is the problem in this proc. CREATE Procedure sp_tab @tablename nvarchar(517), @flags int = 0, @orderby nvarchar(10) = null, @flags2 int = 0 As if @flags is null select @flags = 0 if (@tablename = N'?') begin print N'' print N'Usage: sp_table_struct @tablename, @flags...

    Amitshukla60 pointsBadges:
  • Formview from gridview in Visual Basic

    How does one automate by clicking a row in gridview to show a form populated with the clicked row data in visual basic for windows not asp.net

    Rafik25 pointsBadges:
  • Linked Server Query Returns Incomplete Results

    I have set up a linked server using Microsoft OLE DB Provider for ODBC Driver to an Oracle DB ODBC DSN. The Oracle table I'm querying has 865 rows but when I try to fetch all the rows I only get back 766 rows. Why am I not getting the complete results? Here is the query I'm using: select * from...

    Apickel350 pointsBadges:
  • Execute trigger only on update of selected fields

    We have created some trigger programs in COBOL that should be executed only if certain fields change. When creating a SQL-After trigger and -program on a file I can specify that the trigger should run only when specified fields are updated by using: AFTER UPDATE OF {fields} ON {file}. Unfotunately...

    r.otto810 pointsBadges:
  • Install MySQL as Non-Root User

    Have you been able to install MySQL as a non-root user, if so what steps did you follow.

    Djp0820 pointsBadges:
  • Photo upload in a profile with PHP and MySQL?

    Please help me by giving script for uploading and updating member photo in his profile using php and mysql

    Shreeuram45 pointsBadges:
  • How can I email a query output from Access 2003?

    I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do so

    MahmoudAly5 pointsBadges:
  • Multiple user login in one Access 2007 database

    I found a lot of answers how to make a multiuser login but when count of users is known. I want to put all my users and passwords in one table and search for them. For example (I am admin with full access. I want to add a new user and give him different access. So I'll put a new record in my...

    Johnnyt05 pointsBadges:
  • Recursive Association with compound primary key in SQL database

    Hello, I'm afraid I'm very new to this and really struggling. I have a table with a compound primary key composing of Code, Date, Client to represent an attendee on a course. I need to include a 'Lead Client' column to represent a recursive relationship where one attendee can be nominated to lead...

    Littlegreen15 pointsBadges:
  • Zipping CSV to AS/400

    Hi I have one doubt in zipping the CSV files... Iam keeping the daily running reports in My IFS called ABC folder. wrklnk ABC.This folder contains 10 csv files with date extension. Now i want to zip all this CSV files and FTP to another system. how to do this in AS400.? please help me out in...

    iiiiiiiiiiiii335 pointsBadges:
  • How to connect Forms 6i with MS Access

    Can anyone help me in connecting the Oracle Forms 6i with Microsoft Access Database. Please send me an example also, so that i may be understood properly and clear my logics tooooo. Best Regards Rashid Shah

    SuperRad40 pointsBadges:
  • Problem with Access 2010 and Adobe PDF creating a file.

    I am trying to create a PDF file from within Access 2010. I just converted from Windows XP running Access 2003. Now I am on Windows 7 with Access 2010. The following work on 2003 but the PDF creations doesn’t on 2010. Private Sub PrintInvoiceWithForm_Click() On Error GoTo...

    DPaxton180 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following