When my php executes the db2 insert, I get error 7008. Any ideas what I might try to get it working ? The PF is new with *all public authority and no trigger nor journal. I manually added 1 record via green-screen SQL with the same context as what is assembled in my php. Here’s…

We have a web service for placing orders and sending them to our iSeries. Basically front ending the EDI package on the iSeries. If the data is sent over without errors on the SQL insert to the DB2 databases the job runs. If there are run time errors during order processing the errors are logged…

I need to sum gift amounts based on the specific date a solicitor was assigned to the account.IE: One account has given gifts since 2/25/1999 however the solicitor for this account was not assigned until 5/15/2002. I want to sum all gifts this account has given since 5/15/2002.

How can I add/remove recipients on existing scheduled jobs without having to recreate the entire job? Thanks

How to generate a Crystal Report report through java by using MS-Access 2003. Steps for generating the report through Java.back end MS-Access2003.

I need a sample template for EDIFACT DESADV to IDOC Delivery05 inbound.

Hi, I have the following fields to work with: ID #, issue #, meeting #, prior meeting dates, and status. I keep isolating the old records that have already been rescheduled along with the ones that need to be rescheduled. Any ideas would be appreciated. Thanks! Babeas

How to micro zoom bigger or smaller a drawing once in the layout space?

We have a user who wants to use Crystal Reports to access data on an MS SQL server. She also has access to view limited data on the iSeries using an iSeries application with built-in security. How can we prevent her from accessing data on the iSeries using Crystal Reports. Is there a service we…

How can purchase orders received from an EDI transmission be ‘bulk entered’ from a CSV or Excel file into the AS/400?

I have created a report with all parts in our warehouse with part location, qty and transaction dates. Since there are various locations with qty(or no qty) and various transaction dates linked to them, I can not max and get the info I need. I need all parts that have qty (or no qty) in…

Current Syntax: IsNull ({DISPOSITION.DISPOSITION}) AND {HEARING.OFFICERID}=987 AND {HEARING.HEARING_DATE}<CurrentDate I am trying to isolate appeals that need to be rescheduled. They can be rescheduled multiple times, and I end up with a lot of appeals in my results that have already been rescheduled. Any ideas would be greatly appreciated. This will allow us to go paperless…

Arrange following activities in the sequence of occurrence in a MDM program: A) Design logical MDM model B) Understand source and target systems C) Understand organization structure D) Perform data profiling A. C,B,D,A B. C,B,A,D C. D,A,C,B D. None of above

What is syndication means in MDM

The following transaction codes have disappeared from our PI environment.  They are in the ERP environment.   CG3Y   CG3z   How could this happen?

Usually DTM03 automatically changes to match BSN04. What would cause DTM03 to be left at the default time? And what, if anything, can be done to fix this?

We are a small telecommunication company that has a bid in with a customer who is asking for a breakdown of materials vs. labor cost. What is the best way to show this?

The error is: “The page size was not large enough to format the contents of an object in the report”.

I can draw a 10′ line. How can I write in dimensions as 20′?

For some reason I managed to change the color of the AutoCAD icon/application button to purple. How do I change it back?