Need to identify the next sequence of number in a character field in DB2
I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found [...]
Answer Question
| December 18, 2012 7:34 AM
AS/400 V6r1m0, DB2
I have a scenario where I need to find the next sequence of numbers in a character field. I found the starting position by using the LOCATE command but need to find the next sequence in the same row if anything. For Example: Issue Number : 01 Card Number 1234 5678 9012 3456. I found [...]
Answer Question
| December 18, 2012 7:34 AM
AS/400 V6r1m0, DB2
QR Code barcodes in .NET
How could I generate barcodes not in black and white, but still it could be scanned, it this possible?
Answer Question
| December 17, 2012 3:58 AM
.NET, Barcode
How could I generate barcodes not in black and white, but still it could be scanned, it this possible?
Answer Question
| December 17, 2012 3:58 AM
.NET, Barcode
pb exe runtime eror – does not connect to db2 database from client machine
I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on the [...]
Answer Question
| December 13, 2012 11:19 AM
DB2, pb9
I have created an application using PB9.0.2 with database as db2 server db 9.7 on Windows XP Professional. the application works fine on all machines having PB installed. I have created an exe and copied the necessary files and dlls. this exe works fine on my machine, but does not work at all on the [...]
Answer Question
| December 13, 2012 11:19 AM
DB2, pb9
Application of SAS programming
Please help me with my question, Is SAS Programming is applicable in Broking companies? and if yes can you tell me how and also the name of companies.
Answer Question
| December 12, 2012 8:29 AM
SAS, SAS Business Intelligence software
Please help me with my question, Is SAS Programming is applicable in Broking companies? and if yes can you tell me how and also the name of companies.
Answer Question
| December 12, 2012 8:29 AM
SAS, SAS Business Intelligence software
DOB ISNULL
I need help writing a formula to show 00/00/0000 when dob isnull else dob Thanks!
Answer Question
| December 11, 2012 7:54 PM
Crystal Report
I need help writing a formula to show 00/00/0000 when dob isnull else dob Thanks!
Answer Question
| December 11, 2012 7:54 PM
Crystal Report
Anyone familiar with 4D front end to DB2 database
Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I’ve tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting…however I can’t get DB2 to maintain the formatting and I used DDS to to generate the physical file [...]
Answer Question
| November 27, 2012 2:54 AM
DB2, iSeries
Has anyone had experience with using 4D (4th Dimension) as a front end of IBM DB2 on iSeries? I’ve tried FTPing a database, it was downloaded to a PC into Excel, Excel had no problem retaining formatting…however I can’t get DB2 to maintain the formatting and I used DDS to to generate the physical file [...]
Answer Question
| November 27, 2012 2:54 AM
DB2, iSeries
Add Database Field to Report
Why am I barred from adding new fields (e.g. Text, Fields, Formulas) to my report. I am able to move and alter existing fields but not add new one. This problem began suddenly and after reloading Crystal 8.5, the problem still exists.
Answer Question
| November 21, 2012 10:57 PM
Crystal Reports 8.5, Crystal Reports fields
Why am I barred from adding new fields (e.g. Text, Fields, Formulas) to my report. I am able to move and alter existing fields but not add new one. This problem began suddenly and after reloading Crystal 8.5, the problem still exists.
Answer Question
| November 21, 2012 10:57 PM
Crystal Reports 8.5, Crystal Reports fields
Will litigation against Huawei affect me as a buyer?
I have been working on assessing a few leading network equipment vendors in the likes of Cisco, HP, Juniper, etc., to procure Layer 2 switches. I am currently assessing the capabilities of Huawei and i have been hearing about a litigation raised by Nortel (Avaya) against Huawei on their Layer 2 switches, however, I have [...]
Answer Question
| November 20, 2012 6:12 PM
Cisco, HP, Huawei, Juniper, Layer 2 switches, Unified Communications, Unified Communications Hardware
I have been working on assessing a few leading network equipment vendors in the likes of Cisco, HP, Juniper, etc., to procure Layer 2 switches. I am currently assessing the capabilities of Huawei and i have been hearing about a litigation raised by Nortel (Avaya) against Huawei on their Layer 2 switches, however, I have [...]
Answer Question
| November 20, 2012 6:12 PM
Cisco, HP, Huawei, Juniper, Layer 2 switches, Unified Communications, Unified Communications Hardware
Automation of PO expiation
Hi, My name is sreenu, and am working currently working on Maximo 5.2 ERP for procurement process. Question: – can we automate the process of PO copy expiation when the PO gets approved by the final approver by auto mailing process, rather than sending it manually to the supplier for expiation which is consume of [...]
Answer Question
| November 19, 2012 9:11 AM
ERP, Maximo 5.2
Hi, My name is sreenu, and am working currently working on Maximo 5.2 ERP for procurement process. Question: – can we automate the process of PO copy expiation when the PO gets approved by the final approver by auto mailing process, rather than sending it manually to the supplier for expiation which is consume of [...]
Answer Question
| November 19, 2012 9:11 AM
ERP, Maximo 5.2
CPYF
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
Is there any way to create a new physical file(say PF2) with same structure/fields as in a logical file(say LF1, whose physical file is PF1). One way is to use CPYF to create PF2 from LF1 but I dont wan’t any data to be copied from LF1 to PF2 (dont want to use clrpfm after [...]
Answer Question
| November 17, 2012 7:47 PM
AS400 Command, CPYF, DB2
Opening balance in Tally ERP
How can I give an opening balance of opening stock and closing stock in Tally ERP 9?
Answer Question
| November 11, 2012 7:06 AM
ERP, Tally
How can I give an opening balance of opening stock and closing stock in Tally ERP 9?
Answer Question
| November 11, 2012 7:06 AM
ERP, Tally
ERP data safe
Do you think that your enterprise data is safe on Cloud based application?
Answer Question
| November 8, 2012 6:42 AM
Cloud Applications, Cloud Security, Enterprise data management
Do you think that your enterprise data is safe on Cloud based application?
Answer Question
| November 8, 2012 6:42 AM
Cloud Applications, Cloud Security, Enterprise data management
Save to older version of SPSS
Can I save a version 20 .sav file to an older version, such as 17?
Answer Question
| November 2, 2012 11:02 PM
SPSS, SPSS 17
Can I save a version 20 .sav file to an older version, such as 17?
Answer Question
| November 2, 2012 11:02 PM
SPSS, SPSS 17
Limit on Number of Records Returned by a Query
Are you familiar with a Crystal Reports issue that will not allow a report to return over a certain number of records? In our case, the number is 8500 records. Both Crystal and the database being queried are on a remote server, I suppose that some throttle is set for performance reasons?
Answer Question
| November 2, 2012 8:17 PM
Crystal Reports, Crystal Reports Record
Are you familiar with a Crystal Reports issue that will not allow a report to return over a certain number of records? In our case, the number is 8500 records. Both Crystal and the database being queried are on a remote server, I suppose that some throttle is set for performance reasons?
Answer Question
| November 2, 2012 8:17 PM
Crystal Reports, Crystal Reports Record
RFID
I need to know the benefits of the RFID technology in the construction industry please?
Answer Question
| November 1, 2012 2:11 PM
RFID
I need to know the benefits of the RFID technology in the construction industry please?
Answer Question
| November 1, 2012 2:11 PM
RFID
Large data text block in Crystal Reports 8.5
My report has a large text block, this is causing problems because it keep jumping to the second page rather than starting from page one spilling over to page two naturally.
Answer Question
| October 29, 2012 3:30 PM
Crystal Reports 8.5, Crystal Reports error messages
My report has a large text block, this is causing problems because it keep jumping to the second page rather than starting from page one spilling over to page two naturally.
Answer Question
| October 29, 2012 3:30 PM
Crystal Reports 8.5, Crystal Reports error messages
Restoring tabs in AutoCAD 2007
The tabs (at the bottom of my screen) for my detail drawings have suddenly disappeared. How do I restore them?
Answer Question
| October 23, 2012 1:58 PM
Autocad 2007, AutoCAD Errors
The tabs (at the bottom of my screen) for my detail drawings have suddenly disappeared. How do I restore them?
Answer Question
| October 23, 2012 1:58 PM
Autocad 2007, AutoCAD Errors
How to grab data after a specific character
Hi Guys, I was wondering if any of you knows how to grab data after a specific character. Right now, I have a comment field that has various information in it. the field is called {misc_comment} here is the way the data is laid out: 00VISA 2 /IN: 20120125 00DENTALCENTER /IN: 2012APRIL 00AMAZON/IN: 557878 I [...]
Answer Question
| October 22, 2012 7:50 PM
Crystal Reports 11.5
Hi Guys, I was wondering if any of you knows how to grab data after a specific character. Right now, I have a comment field that has various information in it. the field is called {misc_comment} here is the way the data is laid out: 00VISA 2 /IN: 20120125 00DENTALCENTER /IN: 2012APRIL 00AMAZON/IN: 557878 I [...]
Answer Question
| October 22, 2012 7:50 PM
Crystal Reports 11.5
Transfers
I want to transfer everything on on my old hard drive to my new tower. The disk drive on my old computer is broken…can I connect directly (like a usb cable) and do the transfer?
Answer Question
| October 22, 2012 6:45 PM
new computer, old computer, Transfer
I want to transfer everything on on my old hard drive to my new tower. The disk drive on my old computer is broken…can I connect directly (like a usb cable) and do the transfer?
Answer Question
| October 22, 2012 6:45 PM
new computer, old computer, Transfer
crystal reports
i have table inn my crystal report at the testing phase an cell contained very long paragraph and that caused the report to skip half of the page and add the long record to new page . how can i let the report behave in the right way like Excel for example. thanks in advance
Answer Question
| October 21, 2012 12:17 PM
Crystal Reports
i have table inn my crystal report at the testing phase an cell contained very long paragraph and that caused the report to skip half of the page and add the long record to new page . how can i let the report behave in the right way like Excel for example. thanks in advance
Answer Question
| October 21, 2012 12:17 PM
Crystal Reports
