Get answers.  Share knowledge.  Collaborate with peers.




Getting error
Hi, I wrote a code in VB Script to query on database and result gets write in file, but there is one problem with on column in query, if I remove that column from query then code working very fine and runs but with that column it’s giving error “invalid procedure call or argument”   [...]

Answer Question   |  May 9, 2013  5:43 AM
VB script
asked by:
5 pts.

taplib issue
In one system tapmlb01 device varied off and back on after an IPL. please help me WHY this needs to go offline/online for these systems when it doesn’t do the same on the rest

Answer Question   |  November 18, 2011  5:12 AM
AS 400
asked by:
85 pts.

IPL issue
i am getting an IPL/PATCH screen after pwrdwnsys. Re-performed IPL by selecting option 1. Additional options were for installing an OS, patching, etc. Doing the IPL like this brings the system through selecting ptfs. The Control Panel shows Manual instead of Normal. This is causing a delay in the IPL process.Please help me to avoid [...]

Answer Question   |  November 29, 2011  3:25 AM
AS/400 errors at IPL, AS/400 IPL
asked by:
85 pts.

IT Data Updates and Auditors
I would like to hear how other shops deal with auditors regarding data updates made by IT staff.   We use DFU/FILMNT/SQL for occasional data fixes. We print and file a log with who and why the change was made. Then to appease the auditors, we journal pretty much everything. A report is generated twice a [...]

Answer Question   |  November 18, 2011  12:01 AM
AS/400, Auditors, DFU, FILMNT, iSeries, SQL
asked by:
185 pts.

CPF4328 & FILE CONSTRAINT with *RESTRICT Rules
10 years ago we sent out a pair of PF tied together by a constraint. Client is now receiving CPF4328 while updating “parent” file. DLT & UPD rules were created as *RESTRICT which should allow update without journaling. Is there a way to see DLT & UPD rules on green screen? Or, should I just [...]

Answer Question   |  January 31, 2012  7:37 PM
AS/400, Constraint, CPF4328, PF
asked by:
45 pts.

AS400 DSPF Overlay
I’m having problems with a simple overlay issue. I have a screen where a user can do an F4 and a window of the values from a table will appear in a SFL. All works well; except the new wilndow does not overlay the previous screen. THe old screen goes away and I just have [...]

Answer Question   |  November 16, 2011  7:29 PM
AS/400
asked by:
33,730 pts.

Which encryption algorithm is the most recommended by the PCI standard?
Does anyone know if AKA ver 2 protocol is PCI compliance?

Answer Question   |  April 9, 2012  5:08 PM
Encryption, PCI
asked by:
5 pts.

Thoughts on SCOM 2012 Release Candidate?
Back in August, I asked a few experts about their thoughts on Microsoft’s System Center 2012 beta release. There were some mixed opinions. Now that the latest version is here, has anything improved? Curious to know what you’re finding and if you plan to upgrade anytime soon.

Answer Question   |  November 15, 2011  4:57 PM
Microsoft, System Center Operations Manager
asked by:
2,070 pts.

MS-Access data inserted in to Oracle 11g CLOB
I have an old MS-Access database storing data in bullet point format. I need to transfer this data across to an Oracle 11g EE database version at the same time maintain the MS-Access formatting.  How do I go about this?

Answer Question   |  November 15, 2011  4:08 PM
CLOB, formatting, MS Access, Oracle
asked by:
5 pts.

Dual DATE / DATETIME (data-type) formats possible
DB2 apps retrieve DATE cols in US format, DATEIME in ISO; can SQLServer replicate this w/o using CONVERT? If possible, would prevent massive code chgs.

Answer Question   |  November 16, 2011  2:18 PM
Dual Date formats, MicroFocus Enterpise Server, NetExpress, SQL Server, SQL Server Date format, VSE
asked by:
5 pts.

user profile
what is the parameter accounting code in userprofile?

Answer Question   |  November 16, 2011  12:59 PM
AS/400
asked by:
1,350 pts.

Encoded vector view in AS400
Hi I have a question on encoded vector view.what exactly it is. As iam using normal logical files using DDS.this logical files iam using in rpgle programs to read the file and update in my work file. Now my people are saying that logical files are taking more space on system. They are suggesting me [...]

Answer Question   |  November 16, 2011  12:53 PM
AS/400
asked by:
335 pts.

InfoSec Consultation
Hello, I would like to ask you a question. I have 3 years experience in InfoSec, I want to advance my career by either: 1) take a master degree in Security. 2) take trainings such as PMP, CISSP, CISA, CISM. Please advice me which way shall I go with. Please acknowledge that my money is [...]

Answer Question   |  January 31, 2012  11:20 AM
IT certification and training
asked by:
30 pts.

my interface not working properly
Hi to and thanks to every one who r reading my problem My interface is not working and showing the error if i stop and start the soa server and managed servers. i am getting the below error The composite OtmVoucherToOracleApInvoice (1.0) is not available. This could happen because either the composite has been undeployed [...]

Answer Question   |  November 15, 2011  11:12 AM
Oracle
asked by:
5 pts.

how can we login into sybase using an encrypted password
Anyone can help me on this:   I have a encrypted password prepared and nowi want to login into the sybase server how can i do that…????

Answer Question   |  April 9, 2012  6:29 AM
Sybase
asked by:
5 pts.

Question on CL.
Hi Group, I would like to enter input to a CL pgm through console. For example, My CL PGM should take file name as the input from the console and has to display the number of records that are present in that file. Thanks in Advance, MVRK

Answer Question   |  November 16, 2011  1:40 AM
CL/400
asked by:
340 pts.

VPN Trace routes
Trying to solve a slowness issue from my office location through a VPN to my database server.  My location is California, and my database is hosted in Atlanta.  My users are complaining of slowness to the database server.  If I do a trace route to the database server is only gives me 3 hops.  Is [...]

Answer Question   |  June 21, 2012  8:11 PM
Networking, VPN issue
asked by:
15 pts.

how do I open and update EXCEL sheetsheet from AS400?
this batch file is called by a RPG program from AS400, i5/OS the first four lines executes properly, then it goes into a TIMW that never ends. If I exclude the  c:spreadsheetopexcels.exe statement (my primary need), it executes properly. ************************************************************************************* *mybatfile.bat cd c: cd c:SPREADSHEET rem the line below creates an excel spreadsheet ESA002F2.xls “c:program [...]

Answer Question   |  March 20, 2012  7:17 PM
AS/400, Excel Scripts
asked by:
5 pts.

Seeking Masters Degree and Certs at once
I have a BA in Telecommunications and have extensive Help Desk experience but I’ve decided I want to run with the big dogs and get some real credentials.  I am looking for a Fast Track (For students with non-computer related degrees) Master’s Degree Program in IT or CS that also has a clear aim to [...]

Answer Question   |  April 5, 2012  6:43 PM
Cisco certification, IT careers, IT training, IT training and certifications, Microsoft Certification
asked by:
5 pts.

Accessing a Server on a different subnet
I have a t1 line that goes into a switch, off the switch there are two routers one operating on the subnet 192.168.1.1 and the other on 192.168.0.1. Both routers have individual static ip addresses. I have a ReadyNAS storage device on 192.168.1.100. I want to be able to access the server from both subnets. [...]

Answer Question   |  November 15, 2011  6:14 PM
NAS, Networking, ReadyNAS, Routers, Subnets
asked by:
5 pts.