1 - 20 of 1638
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>

Coding to prevent table overflows withing programs

In this new world of zero tollerance for abends and the goal of 100% production stability, I have been charged with determining the best method to prevent abends due to internal program table overflows.  Our environment has Cobol, Eztrieve and Assembler programs with internal tables.  We are...

Answer Question   |  Nov 6 2009  5:14 PM GMT
Buffer overflow, ABEND, COBOL
asked by NanetteHaraden

  5 pts.

How to combine 2 linked Excel tables in access 2003 with same field names, using query?

I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...

View Answer   |  Nov 5 2009  6:37 PM GMT
Access 2003, Data management, Microsoft Access query
asked by Accesstables

  5 pts.

Record Count Crystal Reports 2008

I currently have a report where data pulls from a table labeled clients for things such as patient name, address, etc.  However, I would also like to get a count of orders that the client has made.  These orders are stored in a separate table and not counted, but linked by a client id number. ...

View Answer   |  Nov 5 2009  5:36 PM GMT
Crystal Reports 2008, Crystal Reports
asked by CraigN

  5 pts.

The IT Blog Top 10: Nov. 5, 2009

10. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover has put together a useful tutorial for Sun’s xVM VirtualBox. 9. How to reset the Cisco Catalyst Switch to Factory Defaults Yasir Irfan offers some advice for those needing a fresh late on Catalyst switches. 8. Independent...

Answer Question   |  Nov 5 2009  4:01 PM GMT
ITKE, Channel, CIO
asked by Michael Morisy

  610 pts.

Troubleshooting Data Mining in SQL Server Analysis Services 2005

I want to run the Data Mining tool in SQL Server Analysis Services 2005, but I can only get to the processing stage: It hangs (NOT RESPONDING) when I try to go into the Mining Model Viewer. Could this be a PC or SQL config problem? How do I resolve this problem?     Software/Hardware used:...

asked by SQL Server Ask the Experts

  2435 pts.

The most-watched IT questions this week: Nov. 3, 2009

Here are the 10 most watched questions on ITKE: There’s some great discussions going on. Go answer a question now and take your shot at winning a TV: 1. Problem installing Exchange 2007 Management Tools was posed by Labnuke99 and answered by Mshen. 2. What Event ID was asked by Newbiepeon and...

Answer Question   |  Nov 4 2009  2:33 PM GMT
ITKE, AS/400, Channel
asked by Michael Morisy

  610 pts.

Crystal 9 Subreport will not run

I have a Crystal 9 report that is working properly, but the sub report (also in Crystal 9), will not run.  I have tried removing it and re-adding it with a new connection and it still will not run.  Everything appears to be linked properly, but yet it will not open. Thanks; Gillian ...

asked by NCGillian

  5 pts.

db2/400

Hi, on db2 hw to give the output query using webquery and consoal? And what is the meaning of webquery and consol?

View Answer   |  Nov 3 2009  12:06 AM GMT
AS/400 simulator, DB2/400, DB2
asked by I6

  195 pts.

Procedure Pointer

How to use a procedure pointer? Other than procedures where pointers concept can be applicable in AS/400? Software/Hardware used: Iseries

View Answer   |  Oct 30 2009  11:38 AM GMT
AS/400 Procedure Pointer, AS/400 Pointers, AS/400
asked by Kar

  95 pts.

The IT Blog Top 10: Oct. 29, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert has written a guide on how to choose the right size for VMFS datastores. 9. How to use command line arguments in VBScript via the Wscript.Arguments Object Jerry Lees explains a helpful VBScript trick. 8. Using VRDP to view...

Answer Question   |  Oct 29 2009  7:08 PM GMT
IT Blogs, ITKE, AS/400
asked by ITKE

  10120 pts.

Workstation ID/IP Address

HI, I have a situation we have made 500 device description (e.g. IT01, IT02...) for display and assigned each workstation id to user. After creating devices we changed the system value QAUTOCFG=0 and QAUTOVRT=0. Now If A user is using B user worksation ID so B user is unable to get signon screen...

asked by Abiha6325

  45 pts.

External DB2 Database link/trigger

In Oracle I can register a database link to other data sources. For example, through ODBC I have registered DB2 as a database link. In this way I can read/insert/update from/into DB2 tables. Software/Hardware used: i5 i5/os v5m4

View Answer   |  Oct 26 2009  10:42 AM GMT
AS/400 database, DB2/400, i5/OS
asked by R.otto

  375 pts.

SPSS Binary Regression

Please could you help me out. 1) Question I have a binary question. It involves the sex op people being surveyed. I have to enter (into SPSS) if there are "Male" or "Female". After I have entered "Male" or "Female" can SPSS convert "0" for Male and "1" for "Female"? Thanks. Software/Hardware...

View Answer   |  Oct 24 2009  7:56 PM GMT
SPSS
asked by Harry19192929

  5 pts.

Windows Server and Crystal Reports

I upgraded to Windows Server 2008. Now when I try to display or print a Crystal Report from my application it throws me out of the application. My Crystal Reports version is 8.5.0.217 Do I need an update to Crystal Reports to get this to work on a Windows Server 2008?

asked by Smythprog

  25 pts.

AS/400 file transfer window disappears

as400 file transfer window drops to the bottom never to return.

View Answer   |  Oct 22 2009  3:21 PM GMT
AS/400 File Transfer, DB2
asked by Dothendo

  15 pts.

Can anyone tell me how to put more space between the dimension text and fraction of an inch at the end of the text? I assume it is a dim variable.

When dimemsioning in achitectural format, there is almost no space between the inch and fraction of an inch in the end ot the dimension text. Does anyone know if there is a dimension variable for incrasing this space, or any other way? Thanks for your help. I'm using Acad 2008, but had this...

Answer Question   |  Oct 21 2009  6:13 PM GMT
AutoCAD 2008, AutoCAD
asked by JustinNichols

  10 pts.

Is the new WRKDBF out yet?

Anyone heard if the efforts to recreate a WRKDBF utility have borne fruit yet? Once again I find myself needing a general purpose file view utility, and hover on the brink of writing something, for I saw somewhere that a new one was being put together. Software/Hardware used: i5 v5r4

View Answer   |  Oct 21 2009  1:51 PM GMT
i5, iSeries, AS/400
asked by Yorkshireman

  3200 pts.

Count distinct values in Proc Tabulate

Hi How can you count distinct values in a Proc Tabulate table? E.g. if you want to count distinct customer numbers. Much like count(distinct(customer_number)) in SQL. Regards, Laurits Software/Hardware used: SAS Base 9.3.1

Answer Question   |  Oct 21 2009  8:20 AM GMT
SAS, SAS Base 9.3.1
asked by Laurits

  5 pts.

STORED PROCEDURE

Hi All i search to make procedure in strsql please can anybody help me and search code open text file from the procedure and put data on  it   Software/Hardware used: AS/400 sql400 DB2

Answer Question   |  Oct 21 2009  5:14 AM GMT
SQL stored procedures, SQL/400, DB2
asked by AS400SQL

  10 pts.

The most-watched IT questions this week: Oct. 20, 2009

Here are the 5 most watched questions on ITKE: There's some great discussions going on ranging from SQL to diagnosing app crashes. Go answer a question now and take your shot at winning a TV, or check out the rest of the top 10 on the Community Blog: 1.ORA-31672 in oracle 11g tops the list, with...

View Answer   |  Oct 20 2009  6:20 PM GMT
ITKE, AS/400, Channel
asked by Michael Morisy

  610 pts.

1 - 20 of 1638
<<PREVIOUS 1|2|3|4|5|6|7|8|9|10 NEXT>>