• How to disable auto audentity of a DB2/400 table

    Hello, For a migration data project (from SQL/Server to DB2/400), we need to disable the auto identifiers of a DB2/400 table. On SQL Server, the equivalent command is "set identity_insert MyTable off". Thank you in advance JC Cherid

    TheWorldAsGarp5 pointsBadges:
  • Create an Entity Relationship Diagram for a working database (SQL developer)?

    How can I create an Entity Relationship Diagram for a working database (SQL Developer)?

    sonali00725 pointsBadges:
  • Can I import a GP Report into Access?

    I work for a company that doesn't have an IT background. They seem to live in Excel, FilePro, and they recently installed GP 2016, but they do not understand how to use it fully. I noticed that I can do a query and print out all my purchase orders from GP and save them to an excel file. I'm trying...

    ctackett64075 pointsBadges:
  • Under what circumstances would you not use a database?

    For all the experts out there, under what circumstances would you not use a database?

    mulokisamuel5 pointsBadges:
  • Accessing IBM MQ via a batch job running on an iASP

    I have an IBM i batch job BATCH1 that is running under a user profile PRF1 with an independent ASP IASP1 defined in the job description JOBD1 used by PRF1. BATCH1 is running under commitment control, *JOB scoped. I have a queue manager configured in *SYSBAS (QMGR library in *SYSBAS). I am getting...

    Jpjawili135 pointsBadges:
  • SAP HANA performance while reporting

    Hi, I Have doubt regarding HANA. We have ECC on HANA system, we used the ECC tables to building the views and we are using those for reporting. If users post new records when we do reporting on the views. How the performance will be handled.

    MoahnReddy5 pointsBadges:
  • DB2 hex values in SQL causing problem

    Ok here's one I cannot figure out. Here are the PO#s that show in our green screen software and they look fine     5-824101 S1079682 33­-548504­-D RMA 001904          REASON CODE 11  8075-089          1V 76139-6200        88   But if I write a SQL to extract them the PO#...

    ToddN200097,105 pointsBadges:
  • How to design a server with a database

    I want to design a server with a database and this database is updated from raspberry pi and then save this data to the cloud. I don't know where to begin I need to know what courses that I need to take and skills that I should gain to implement this task. Thanks in advance.

    engeng195 pointsBadges:
  • Thermal Printer command code

    I need to generate a pulse by using the command "esc p" to a Pos-x thermal printer so that the printer prints nothing but sends a pulse to the cash draw to open.  I need this to be in VB coding to work in a Pull Tab program wrote in Access 2010. Could somebody please help me with? Thanks, Larry

    LarryZable5 pointsBadges:
  • MySQL server will not startup on Windows 10 machine

    For some reason, MySQL Server will not startup on my Windows 10 machine. It worked the last time I used it (roughly two weeks ago). I don't have any other processes running and I tried to use different ports but that didn't work. Any suggestions here would be awesome.

    ITKE1,063,195 pointsBadges:
  • How change work of Oracle database engine?

    When running a query, we have result of query one time. If it happens, the error while running query we will not have any result. I want to how change on database engine to have part of query if happen bug while running query. I want any search in subject. Thank you very much!

    zaheray15 pointsBadges:
  • Microsoft Access 2007 database will not open in Access 2010

    I'm working on a huge project for my department. We have an Access 2007 database and currently works on my PC (and it has .ACCDB formatted files). I sent it to a co-worker (who has Access 2013) and he tried to open it: All he's getting is compatibility errors. What should we do here? Please help!

    ITKE1,063,195 pointsBadges:
  • Microsoft Access database record

    If I'm updating a person's file, how do I make sure when I update the information about that person, it doesn't automatically update the historical information already associated with that person? For example, I have an instructor who was in grad school, we put his status as "without terminal" and...

    mcentijl5 pointsBadges:
  • Database: Foreign key as reference key

    In a database, is a foreign key a reference key?

    ssrishti78530 pointsBadges:
  • How to connect angularJS to database

    How to connect database and display it on website (AngularJS)?

    Shahpriyanka11075 pointsBadges:
  • Convert CPU time into MIPS

    How to convert CPU time into MIPS? I would like to convert CPU time of an address space into MIPS. Thanks!

    Thrhym0 pointsBadges:
  • How to monitor external ODBC connection(s) for failures and reasons for same

    I am trying to monitor ODBC connections from our website to the iSeries 8 server and find reasons for any failures. Can't seem to find a method.

    randy95975 pointsBadges:
  • How can we migrate Oracle database to Microsoft Access?

    How do I migrate an Oracle database to Microsoft Access?

    Vsrameshkumar025 pointsBadges:
  • Parameter Enter Value in Microsoft Access

    Hi, When I open a form in Microsoft Access or combo box, it shown table parameter. I can't show it?

    hesam100030 pointsBadges:
  • Where can I find the SQL file after MySQL dump?

    After successful connection using SSH and entering right login credentials, I'm not able to find out the backup SQL file. Any help would be really appreciated.

    AjitK292,475 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.

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