• QWCRDTAA on iASP

    Problem: I am trying to access a data area on a library that is in an iASP partition via a java program. I am using jt400 to create a jdbc connection to access the said data area. then getcharacterdataarea.class to basically access the data area, with the filepath parameter pointed to the iASP...

    Jpjawili165 pointsBadges:
  • MySQL database

    I want to create a matric number of student. I declare a matric unique and type varchar but when I put these matric number uil/ibs2015/0165 and uil/ibs2015/0166, it displays an error as duplicate matric number.

    Admin99635 pointsBadges:
  • Cannot connect to SSMS 2017 database

    I'm trying to connect to SSMS 2017 database from my Windows 10 machine but I can't at all. I've uninstalled / reinstalled SSMS but that didn't help. Nothing changed in my security settings (antivirus). Here's the error message I'm getting: A network-related or instance-specific error occurred while...

    ITKE1,068,555 pointsBadges:
  • Best way to set up longitudinal database

    Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester - but on a larger scale - who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and...

    admstr5 pointsBadges:
  • How to start learning computer architecture

    I want to learn computer architecture but I'm in C-S (database) so what should I do to learn architecture. Now I'm studying only architecture books and watching few videos.

    AbdullahHanif5 pointsBadges:
  • What’s the maximum MIMEtype length for storing type in a database?

    Would anyone be able to tell me what people are using for the length of a MIMEType field in their databases? The longest one that we use is 72 bytes but we're looking to see if there are longer ones. We've actually started using 250 now but is there anything longer? Thanks for the help.

    ITKE1,068,555 pointsBadges:
  • AS/400 ODBC connection

    How can I restrict SQL reporter to run update and delete query via ODBC connection? I don't want to restrict some profile which are being used by other application to write some records in specific file. Please advise.

    KapilTiwari201850 pointsBadges:
  • Free Database Hosting Services

    I'm looking to develop a few small web apps. I'm looking to have a few of my IT friends and family be my beta testers. What I need is a site where I can have a small hosted database that I can put in the app so they all can use it. Can anyone recommend a few alternatives? I use to have a site at...

    ToddN2000100,375 pointsBadges:
  • Why is my database corrupted?

    Why my database corrupted? And how I repair it?

    Nibras5 pointsBadges:
  • 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:
  • 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...

    Jpjawili165 pointsBadges:
  • DBA user to have access only to specified schema not other schemas

    I want to give a DBA access to a user say "dbauser" but it should act as a DBA only for specified users say user1, user2, user3 not for other users in the DB. And there is other user named "otheruser1" the "dbauser" should not have a DBA access for "otheruser1" user.

    sudhamani5 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:
  • 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#...

    ToddN2000100,375 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,068,555 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.

Following