Simple question about AS/400 query
Maybe for you that will be a stupid question, but I’m taking the first steps and I don’t know what exactly I have to do in the “Specify how to join files” screen. If I put more joints in more rows it is how there was an “and” before every new row? I mean, all [...]

Answer Question   |  May 7, 2010  9:18 AM
AS/400 Query, JOIN statement

Desktop and Helpdesk Job Demand In Sacramento and Bay Area
I’m considering getting the MCSA so I can start doing desktop or helpdesk work. The question is, are there very many desktop or helpdesk jobs in Sacramento or the Bay Area? I come from a technical background and worked in the field troubleshooting and repairing servers, disks and printers on MPE so that gives you [...]

Answer Question   |  September 28, 2008  11:37 PM
Career development, Certifications, Help Desk, IT careers, MCSA, Microsoft Certified Systems Administrator

With a background in satellite communications, what jobs should I look for?
I have been working for the United States Army in satellite communications for six years and am leaving later this year. With this background, what type of civilian jobs should I be looking for? Are there any certifications that would beef up my resume?

Answer Question   |  July 29, 2008  9:21 PM
Career development, Certifications, IT careers, IT jobs, Satellite telecommunications industry, Training and certifications

Can I start a career in IT after 50?
I am nearly 50! But I want to change my career from social services to IT. I have a BS degree in social science. I live near a junior college that offers AS degrees in CIS with concentrations in CCNP or CCNA. Which is the better option? Is it possible to take these classes online? [...]

Answer Question   |  July 11, 2011  9:14 PM
Career development, CCNA, CCNP, Degree programs, IT careers, Networking certifications, Training and certifications

restore AS400 to flat file
How can I restore an AS400 backup tape to flat file? We don’t have an AS 400 system.

Answer Question   |  July 28, 2008  2:29 PM
AS/400 backup, Backup & recovery, Flat files

IT Jobs are going to cut down drastically in 2009 globally says a latest survey by IT World Canada.
Do you agree or disagree that the IT jobs by 2009 are going to decrease drastically. If you think the answer is ‘yes’, what is the basis of your opinion? And if you think the answer is ‘no’, why do you think so?

Answer Question   |  July 29, 2008  9:32 AM
IT careers, IT industry

Regarding MyLife
Hi, Myself Vijay.I am having 4 yrs of experience in c++ development.But I think i cant go with development any more becuase its tough for me to handle.So i have two choice : testing and SAP BASIS.As i heard that SAP basis is the grooming field providing good package and covering best scope in future,I [...]

Answer Question   |  July 26, 2008  9:18 AM
Career development, IT careers, SAP careers

How to restrict QMF to execute predefined queries only?
Hi, is there a way to restrict the usage of QMF/390 to predefined queries/procedures only? Some users should not be able to edit or create SQL statements on their own. Thank you very much. Regards Michael

Answer Question   |  July 29, 2008  8:01 AM
DB2, Mainframe, OS/390, QMF, Query Management Facility, z/OS

What is seed and reseed in SQL Server?
What is seeding and reseeding in SQL Server? How to use it? Where is it used? What is the purpose?

Answer Question   |  July 26, 2008  8:01 AM
Seed values, SQL Server administration

join tables with nested select count and group by
hi i am having three tables : state, agencydetail, parentdetaills i am running following queries but i am getting wrong result plz help me out where is the problem select state.state,count(ag.agencycode) as registag,count(ff.agencycode) as reportag,count(inp.regno) as incpwait,count(interp.regno) as intercpwait from state left outer join (select distinct agencycode,state from agencydetail) ag on state.state=ag.state left outer join [...]

Answer Question   |  July 29, 2008  6:28 AM
Database programming, JOIN statement, SELECT statement

Replication Storage
How much storage does Flash SE require?

Answer Question   |  July 29, 2008  6:25 PM
Database replication, Flash

Access 2003 – adding values to a specific record via a query
i have a situation where i have a table whose fields are : -Date reference: is a number which repredents a date in the Date Table (this way it is easier to manupilate dates) -value of payment: the monetary value of the payment that has to be paid at that date -Paid: here i enter [...]

Answer Question   |  July 24, 2008  11:45 AM
Access 2003, Database programming, Microsoft Access

Error In SQL SERVER DataBase
am trying to insert four varchar(50) values in a table which is with a primarykey column id_number. i didnt check : “True” to the null field . so it should not allow null values in table. but while am trying . it allows null values. including primary key column. how is possible ? pls help [...]

Answer Question   |  July 28, 2008  9:41 AM
Database programming, NULL values, Primary keys, SQL Server errors, VARCHAR, Visual Studio, Visual Studio 2008

delete records from a directory with IFS root using CL
How to delete records from a directory with IFS root using CL based on the timestamp of the records.

Answer Question   |  May 6, 2010  6:55 AM
CL, IFS, Timestamp

Access 07 Database to Import to Outlook 07
Hi there, I would like to upload the database I have in Access (07) into my Outlook (07) contacts list. However I can’t seem to find a way to do this. Can any help me? CC

Answer Question   |  July 24, 2008  12:16 AM
Access 2007, Microsoft Access, Outlook, Outlook 2007, Outlook contacts, Outlook Import/Export

Does Siebel 7.7 work on Windows Vista (64-bit)?
My name is Ayman and I’m new on this technology Siebel 7.7. My questions is: * Does Siebel 7.7 work on Windows Vista (64-bit)? * Where can I find Siebel 8.0 software? * Why does Siebel needs ODBC? Thank you so much for your time.

Answer Question   |  July 23, 2008  5:15 PM
CRM software, ODBC, Siebel, Siebel 7.x, Siebel 8.x, Vista

Crystal Reports 6.0 and Windows Vista
Has anyone been successful at running Crystal Reports 6.0 under Vista? I get error File could not be opened: “filename”, at file location: “filename” OK to close followed by error – RptName – Run-time error 20535: Unable to connect: incorrect session parameters or just the 20535 incorrect session parameters. I had these issues trying to [...]

Answer Question   |  July 23, 2008  8:40 PM
Crystal Reports, Crystal Reports 6.0, Error 20535, Microsoft Access, Windows Vista

how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive.
how to Move one file(flat file or PF) which is created in a batch job, to the systems C: drive. sing CL

Answer Question   |  August 15, 2008  6:09 AM
Batch job, CL, Flat files, PF/LF

ESB Exception Propagation Issue
Dear Friends, I am facing a strange problem in the ESB. Here is the issue description. When a ESB is made to call a webservice, where the webservice throws a RuntimeException inside its implementation, the ESB captures it, wraps it and shows it as ESB Exception. In this case the SOAP response from the webservice [...]

Answer Question   |  July 22, 2008  5:49 AM
Enterprise services bus, ESB, SOA, SOAP

Report Question-Is it possible to get a “new user” report when the only date is used also for date they used services?
Is it possible to get a “new user” report when the only date is used also for date they used services? The only fields in the table are Student ID, First Name, Last Name, Date of service and hours used.

Answer Question   |  July 22, 2008  7:49 PM
Access reports, Database programming, Database reporting, Microsoft Access