Questions & Answers

  • How to do auto-increment values in PostgreSQL

    My department is switching over from MySQL to PostgreSQL and we need some help with auto-incrementing values. We saw in the PostgreSQL document that the datatype "serial" should work but we keep getting errors. Thank you very much.

    ITKE346,195 pointsBadges:
  • MySQL: How to restrict certain tables from mysqldump

    Does anyone know of a way to restrict certain tables from the mysqldump command? I'm using the following syntax that only dumps table1 and table2: mysqldump -u username -p database table1 table2 > database.sql Would there be way that I can dump all the others, except for table1 and table2? Would...

    ITKE346,195 pointsBadges:
  • What is the difference between RAM and Cache Memory in SQL Server 2005?

    What is the difference between RAMĀ and Cache Memory?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Construct RPG statements from a file

    Does anyone have any example programs where an RPG statement can be constructed from a file? Example: Below is a file with a result field and conditions. I would like to have the RPG program read the file and execute the statement: IF FIELD1=1 or FIELD4=2 or FIELD6 = 'ABC' then 'XXX'....

    PietaKit35 pointsBadges:
  • How we can import a SQL dump into a PostgreSQL database?

    We're in the process of switching hosts and our old host provided a SQL dump of the PostgreSQL database of our site. Now, we're looking to set it up on a local WAMP server to do some testing. But we're running into an issue with importing that database in the PostgreSQL 9 that we have set up. We've...

    ITKE346,195 pointsBadges:
  • How to run JSP with Tomcat on OS/400 V6R1

    I'm replacing an iSeries by an I5 V6r1 but it appears that I cannot use Tomcat any longer to run JSP applications. What should I do?

    JPPLOU135 pointsBadges:
  • Can data be restored from BRMS whose expire date has passed.

    Can data be restored from a media whose expiry date has passed though it has not been initialized or formatted. Data was stored using BRMS.

    JohnsonMumbai1,160 pointsBadges:
  • How do I get my icon back on Facebook on iPad 4?

    How can I get my icon back on Facebook on my iPad 4?

    Leeharmon11425 pointsBadges:
  • Cisco vs HP

    I have read a lot about the debate between Cisco and HP switches. In what use cases does going with the HP product make a lot of sense and how much of Cisco's installed base is realistically at risk? What are the primary factors that sway decision makers one way or the other?

    Gcc5 pointsBadges:
  • Relation Between virtual memory, cache memory and RAM?

    Hi friends, Hope you all are doing fine. Actually, I am new in the networking field. Can anybody tell me the size relation between virtual, cache and RAM memory in Windows Operating systems? Thanks in advance.

    Balasaheb0 pointsBadges:
  • My USB pen won’t properly go in.

    My USB pen's silvery bit (don't ask me what the technical stuff is, I have no idea), is not going into any USB port whatsoever, I've tried many, because for some reason it keeps going down into the holdy bit. I have to pull it out of it, not completely, but when I try to put it into a port, it just...

    megzeeeh5 pointsBadges:
  • SQL Server database: How to interpret precision and scale of a number

    We have this column in our SQL Server database: decimal(5,2) but we're not sure how to interpret this. When we're looking at it through SQL Server Management Studio, we can see what it means: decimal(Numeric precision, Numeric scale). What does precision and scale mean in real terms?

    ITKE346,195 pointsBadges:
  • Can you send a commercial to a cell phone?

    Why doesn't the industry send commercials to cell phones?

    Dennis745sbcglobalnet15 pointsBadges:
  • How do I insert, update and delete works (internally) in Oracle database?

    Can you explain the states of DB buffer cache, redo log buffer, undo table space etc, when DML statements are executing?

    Pulak555 pointsBadges:
  • Can I import a single MySQL database using a mysqldump?

    Does anyone if it would be possible to actually import a single database from an all databases mysqldump? I've already tried modifying the file manually but it didn't work. Are there any command line options to do this? We're removing a ton of databases but we need the option to restore one if need...

    ITKE346,195 pointsBadges:
  • Making an RPGLE file of data structure only

    Hi all, I have seen an RPGLE file containing only one data structure with a couple of fields nothing else. The fields of the data structure are being populated from a data area and this file is used as a copy source in another program and values of the fields are extracted there. I don't know how...

    hunshabbir71,475 pointsBadges:
  • Qualitative and quantitative approaches in managegement decision making

    What are the different roles that qualitative and quantitative approaches play in managerial decision making?

    samadotey5 pointsBadges:
  • Factors to consider before introducing Information Technology

    A small hotel with low income clients needs to introduce IT, whats factors can it consider before introducing IT

    beatrice5hlatshwayo5 pointsBadges:
  • What is infomation technology?

    Can someone explain to me what information technology is?

    anshthakur5 pointsBadges:
  • KDB files saved in Windows Media Center

    We saved the database on an external hard drive. The icon on the file shows Windows Media Center. The file type is listed as KDB. How can we open this?

    donjohnsonis5 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