DataManagement

Report from CA/View

Hello, I need to write a REXX routine to read the CA/VIEW (SAR) for a particular job and list out all the datasets that are being used in it. Please let me know of any sample code or point me to some documentation where I can read more about this. Thank you. CA/VIEW is the place that all the jobs...

Delphi 5 and Crystal Reports 8.5 and User Function Library

Hello all,    I am trying to create a UFL in Delphi 5 for use in Crystal Reports 8.5.  Does anyone know how to successfully do this?  I have some examples, but they all leave out some information and I end up not being able to create the UFL and use it the way it is supposed to work. Thanks,...

Ideal memory for DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box.

We are running one instance of DB2 (V8 fixpak17a) on 64 bit Linux (SLES10SP2) box. this box is dedicated to Db2. We have 32G of memory. I would like to know what is the ideal amount of memory to be allocated to DB2 and how much for the OS? Also how much of swap space should we have? ...

The IT Blog Top 10: Oct. 1, 2009

10. Choosing a block size when creating VMFS datastores Eric Siebert provides a guide detailing how to choose a block size for VMFS datastores. 9. Using VRDP to view VirtualBox virtual machines remotely Rick Vanover walks through Sun’s xVM VirtualBox’s ability to tap into VRDP remote viewing. ...

export text quality in jpegs from autocad 07

I am producing plans in Autodcad which i then plot to JPEG but when used by estate agents they complain of unclear text on dimensions Software/Hardware used: autocad 2007 to PDF software

how to display tree view data in crystal reports

i want to display data in crystal reports with Tree nodes. how is it possible?? Software/Hardware used: crystal reports 8,Crystal Reports 8.x

DB2 Web Query record count

Is there a simple way to show a count of the rows printed in DB2 Web Query, such as you can to in Query/400?

Data transfer

Any ideas on how to transfer large amounts of data beyond FTP site. Size and time restrictions limit use of FTP so looking for a solution that can handle more and faster

Domino 8.5 Unablie to store document in database, not authorized ...

Hi, I am a Domino Developer and using Domino 8.5. One of my databases (8GB)does not replicate all the documents to all servers.  Error: Unable to store document in CPT01/SJohns Debt CollectS Johnscdb.nsf (NoteID = 5941202) from Debt Collect/S Johns/cdb.nsf (NoteID = 6315334): You are not...

one field not printing Crystal Reports XI

Report has been working for several months. Now field does not show data on preview, but if I browse the field it's there. Thanks

SQL error

I've a cursor to fetch date from DB2/400...When date is stored as 0001-01-01, I get error - Year portion of the Date not in correct range. This is the default date my update program stores when user doesnt enter anything for date field. How can I bypass this error while fetching SQL cursor in my...

system storage

Can anybody say if i make one pf with following DDs R RECORD    ENAME           20A    ESAL               5S0    EDOB                L        DATFMT(*MDY)                                     DATSEP('/') NOW I AM...

SAS OR ORACLE.WHICH IS THE BEST?

TO PERSUE MY CARER IS IT BEST TO DO SAS OR ORACLE? WHICH 1 AMONG THE 2 OFFERS BETTER EARNING JOB? Software/Hardware used: WINDOWS

iSeries Content Manager API Error

I am trying to archive PDF document in iseries Content Manager V5.1 using the APIs provided by IMB in the RPGLE program. The SimLibStoreNewObject is giving error when the ObjectSize parameter is passed with a value 490KB or above. If the ObjectSize parmater is passed as any value below 490KB ,...

Creating Crystal Reports

 am really new to Crystal Reports (currently using version 8.5) and I would like to create a new report based on another.  Basically I am trying change the SQL query of the original report and since I can only view the query, I am assuming that I will have to create a whole new version of the...

Office 2007

I have QMF for Windows 7.2 installed on my computer. I just got Office 2007 installed on my computer. Now, the Excel QMF Add-on is not working properly. I have a query with eight columns. when I use the QMF add-on to retrieve the data, it only retrieves 3 of the columns. How can I get the add-on to...

Luns on a IBM DS4300 need to remove

Recently installed a DS4300 disk. I have a few Ghost LUNs that I cannot delete. How can i remove these? Software/Hardware used: IBM DS4300

The most-watched IT questions this week: Sept. 22, 2009

Curious as to what the most popular IT questions and answers are on  ITKE? So were we! So we’ve been watching the watchlists, so to speak, to bring you the top 10 questions, answers and discussions at the top of user watchlists this week. Read them all at our Community Blog.

mainframe db2 - get current month and year

Please advise. My DB2 statement does not work. gl_date is a date field, format is 'yyyy-mm-dd'. select * from db2 table where year(gl_date) = year(current date) and month(gl_date) = month(current date); Software/Hardware used: DB2 mainframe in Informatica

Not Supported Error in Crystal 8

I have a report designed in Crystal 8 that is ment to display the data from the stored procedure that has 1 parameter passed. SELECT BS.Box_Set_ID,   (int) BS.Date_Stored,  (datetime) BS.Shelf_Location, (varchar (255)) BS.NumOfBoxes,   (int) LTrim(BS.[Description])as Description ,  (varchar...