-
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 paramater pointed to the iASP...
-
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...
Last updated:
1,067,640 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...
Last updated: -
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.
Last updated: -
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.
Last updated:
1,067,640 pointsBadges: -
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.
-
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...
99,905 pointsBadges:
-
Why my database corrupted? And how I repair it?
Last updated: -
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
Last updated: -
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)?
-
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...
-
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.
Last updated: -
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...
Last updated: -
Under what circumstances would you not use a database?
For all the experts out there, under what circumstances would you not use a database?
-
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.
-
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#...
Last updated:
99,905 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.
Last updated: -
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
Last updated: -
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.
Last updated:
1,067,640 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!
Last updated:
