opening pdf document in windows causes large data transfer from file server
We have a 10Mb pdf file which when opened from the samba file server where it is saved, around 400Mb of data is sucked from the samba server to the windows acrobat reader client. We have looked at the data using wireshark and seen nothing unusual, just the typical smb protocol occasionally and a lot [...]

Answer Question   |  February 28, 2012  2:26 PM
Adobe Acrobat, File servers, PDF, Windows

If Statements
how to look up numbers only?

Answer Question   |  March 17, 2012  8:02 PM
IF, IF statement

Download AS400 Physical File to Excel Using VBA
I am in the process of developing an Access database with the intention of using it to control the download of AS/400 physical files into Excel. I am fine developing the Access / Excel side of the data, however I ahve no experience with the AS/400 side of things. The access database will contain information [...]

Answer Question   |  March 17, 2012  9:55 AM
Access, AS/400, excel, VBA

Access 2007 – Controlling Master ID when launching detail form from master form
Hello, I have a master table, and a detail table. (One master record to many detail records, and an ID number that links them.) I have a form that shows the master record data, with a button that launches a form that shows the detail records for that master record. (Where condition =”[Master ID]=” & [...]

Answer Question   |  March 6, 2012  5:44 AM
Access 2007, Access forms, access master form

Is a special authority needed for active socket connections?
Audit log entries for the user QTMHHTTP of type AF subtype K are created, if a PHP script requests a socket connection like LDAP or HTTP with CURL. Does QTMHHTTP need a special authority for this? Which one: *IOSYSCFG, *JOBCTL … ?

Answer Question   |  March 19, 2012  3:23 PM
PHP, Socket, Special Authorities

What’s a college grad to do for work experience?
As a recent college graduate with no experience other than freelance projects online, would contractual programming be enough for employers as work experience? Also, other than internships, what are additional ways to gain work experience? Every job I have been applying for requires experience yet are listed as entry-level. If anyone can provide an insight [...]

Answer Question   |  March 6, 2012  4:21 AM
C#, Java, Programming, Software

Crystal Reports using SQL to create inner join
I am new to Crsytal Reports. I want to join 2 tables using a formula, which I am trying to do in SQL. I created a simple test report and I can get it to work if I don’t put any fields on the report from the joined table.  ie  -  if I just use fields [...]

Answer Question   |  March 6, 2012  9:47 PM
Crystal Report XI, JOIN, SQL

Query Many Tables
I want to run a query on many tables. The answer I am asking is “How many 1s, 2s, and 3s are in all the tables together?” Each semester we get information on standards. How well a student completed a standard – a 1 is the lowest 3 is high proficiency.  The problem is this [...]

Answer Question   |  March 7, 2012  9:16 PM
multiple tables, Query, relationships

SalesForce Data Reader to SQL Table
I am using CozyRoc dll and Script Task to read SF Objects data. How do I write them to a SQL atble using Data Flow task I can connect with VB script and read the data… How do I write to a SQL table?

Answer Question   |  March 6, 2012  3:44 PM
CozyRoc, DataReader, Salesforce, Scripting

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

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

How to display a calendar document, created from a java plugin, in the calendar view of lotus notes
Hi  I have successfully created a calendar document in Lotus Notes through a java plugin. The problem is that the document isn’t shown in the calendar view before the refresh button is hit or F9 is pressed.  The following happens:  - The user hits a button in the calendar view which fires the plugin  - [...]

Answer Question   |  November 14, 2011  9:06 AM
Java, Lotus Notes, Lotus Notes 8.5.1, Lotus Plugins

Problem converting numeric to date data type
I have a zoned decimal field as s 6 and i am trying to convert it to date format as mmddyy in sql…It giving error ..please help me out ..I tried using date and cast function but its not working !!

Answer Question   |  March 19, 2012  11:24 PM
DB2/400, SQL

InfoPath cannot connect to data source
Hi all, I have an InfoPath form in SharePoint 2007 that has dataconnections to SQL server DBs. I have a group of users that have been using them for the past few months with no problem. The permissions on the site have not changed but users can no longer access the Data connections. They get [...]

Answer Question   |  November 14, 2011  7:46 PM
Data Connector, Infopath, SharePoint 2007, SharePoint permissions, SQL

Same file in different libraries and file is defined once in an RPGLE program
I have a coding project that requires the following.

Answer Question   |  March 17, 2012  11:45 PM
Coding, DB LIBRARIES, RPGLE

how to store radio button responses in MySQL
I am creating an online test. Each item has 5 response options (radio buttons with 1-5 values, or 5-1 values depending on the question). How do I store these values in a database, to be able to score the test later?

Answer Question   |  November 8, 2011  1:53 PM
HTML, Radio buttons, SQL, Testing, Web development

Confused about the career path
From last 4 years i am a technical support engineer dealing with AS400 servers and bmc patrol and remedy. Well my organization is giving me an opportunity to switch to QA. I dont know what to do.. There are two options now in front of me either switch to Software Testing or learn more about [...]

Answer Question   |  March 17, 2012  8:41 PM
AS/400, BMC Patrol, QA

How does one start to do software testing?
I work for a Web based Lims (Laboratory Information Management Systems) company (vendor) that supplies this product (LabLynx ELab Lims) to different clients. [strong]We now have the requirement to test software developers’ fixes[/strong] that come from solving problems installing the ELab Lims, from development to test and then to production for use in a lab. My problem [...]

Answer Question   |  November 9, 2011  7:17 PM
Test Strategy Document, Test Strategy template, Test systems, Testing software

Open list of Objects using QGYOLOBJ API
Hi, I’m trying to use the QGYOLOBJ API to get all the objects from one type but always gave me invalid results into the List Information str:   struct SelectionControl {     Qgy_Olobj_SelControl_t selControl ;     char status; }; struct Receiver {     Qgy_Olobj_RecVar_t receiver ;     Qgy_Olobj_KeyData_t keys ; } [...]

Answer Question   |  March 19, 2012  4:28 PM
API, AS/400, ILE c, iSeries, V5R4

Automate SSRS report
I have a monthly task where I have to run an SSRS report for each contractid we service and export each one to excel.  The problem is that there are over 800 contracts and the tool only allows me to enter 1 at a time.  I would like to somehow enter maybe 50 contractid’s and [...]

Answer Question   |  December 8, 2011  4:17 PM
SSRS reports, Visual Studio