How to compare numeric date field with other date fields in SQL?

Delete from LIBXXX/testB where orddtb<=080917 . The above code compare the date as numeric comparison. But I want date comparison. orddtb is declared as (6P 0). Please help me to compare numeric field date with real date. So that I can process the records. That Date field should be dynamic which...

rajeshkmr571220 pointsBadges:

How to reinstall Wi-Fi service after removing malware

I found out today that my Android Wi-Fi contains malware (not sure how it go there). If I were to uninstall it, how can I reinstall it? My AVG antivirus found malware but I'm scared to uninstall it because I'm not sure how to reinstall it. Any thoughts?

ITKE1,067,645 pointsBadges:

Prevent Google Chrome favorites bar removal

I have a bunch of websites (around 10-15) saved in my Google Chrome favorites bar. But when I click on one website, the bar completely disappears. How can I prevent that from happening? I want it to stay in place. Thanks so much.

ITKE1,067,645 pointsBadges:

Restrict user access to specific folder in Ubuntu

Would there happen to be a way that I can restrict a user so he/she only has access to one specific folder? This is on Ubuntu. I don't want them to have access to other folders. How can I pull this off?

ITKE1,067,645 pointsBadges:

Last row timestamp for Excel Online

We're currently using Office 365 with Excel Online. For one of our workbooks, can we get the last updated timestamp for each row? Meaning when it was last updated? Or is this not possible with Excel Online?

ITKE1,067,645 pointsBadges:

Microsoft Office product key already used by someone else

At my job today, my boss asked me to install Microsoft Office 365 on three different computers. But when I got to the installation page, it says this product key has already been entered by someone else. We don't believe anyone else used this. What should we do?

ITKE1,067,645 pointsBadges:

Antivirus works on which layer of network

For my antivirus, which layer of me network will it work on?

Nikskor5 pointsBadges:

SAP ECC vs. SAP S/4 HANA

Can someone explain about the merits and de-merits of going in for S/4 HANA in ERP-SAP, in comparison with SAP-ECC EHP 6?

VIJAYALAKSHMI645 pointsBadges:

Close white information box on session appearance

How do I close white information box at bottom of session?

oroville5 pointsBadges:

Change Google search engine to UK based

How do I change my Google search engine to a UK based one?

SteveatElgin5 pointsBadges:

How to delete OneDrive permanently

I have Microsoft Office installed on a Windows 10 machine. I tried to uninstall OneDrive but it stays installed with all the updates. How can I delete it permanently? Thanks.

ITKE1,067,645 pointsBadges:

How to create Outlook end meeting reminder

Hello, Can I create a way for Outlook to notify me when a meeting is ending (not starting)? When I'm doing work, I sometimes schedule meetings for myself so I don't get distracted on other things. But when that hour is over, I go back and work on different things. Any chance this is possible?

ITKE1,067,645 pointsBadges:

Decompress .CAB files

How to decompress a .CAB file?

colonelgarcia25 pointsBadges:

Omitting a User object when using BRMS

Using the native SAVLIB command it is possible to omit a specific object. Is this possible in BRMS? The library in question is a user library and just one object gets locked during a swa backup we believe which is preventing an automatic job from running due to the object lock. The library is...

Pmaddox140 pointsBadges:

How to create a single member file for each member of a given multi-member file?

Let the file be 'Employee' and its members be 'Trainee', 'Associate', 'Professional', and 'Expert'. I wish to cut the superset of 'Employee', and just get dedicated PFs for 'Trainee', 'Associate', 'Professional' and 'Expert' (so that they can be queried as a first member.)

rajat01170 pointsBadges:

Change link font settings in Notepad++

For Notepad++, how would I be able to change the font settings for links? Basically, I want to reduce the size of the links (and possibly change the color). Can anyone help?

ITKE1,067,645 pointsBadges:

Subfile sort

I have a subfile program for updating, creating, and displaying item information the user can select from to create, view or update detail. The subfile shows item number, description, etc from my main file (i'll call itemnum1)and a vendor item number from an auxiliary file (itemnum2). My question...

filuphaze475 pointsBadges:

Create XML file from AS/400

How I do? How I send via ftp?

JCCaballero5 pointsBadges:

AS/400 Physical file conversion to XML file

Hi, I need to write an RPGLE program to convert an AS/400 physical file to an XML file. Does anyone have a sample code for it? Thanks in advance.

Siri55 pointsBadges:

PDF form links will not open in Adobe Acrobat

Whenever I use interactive PDF forms, the links in the form usually opened with Adobe Acrobat. But now they keep opening in Google Chrome PDF reader. I don't want that. What happened here? I haven't changed any settings lately. I want them to open in Acrobat. Can someone help?

ITKE1,067,645 pointsBadges: