It's interesting that you are mentioning XLS (an obsolete format no longer used) and AS400 (an obsolete computer no longer used.)
You say that your code doesn't work, but it works for me. Please explain enough detail to make it fail the way it is failing for you.
Search found 658 matches
- Mon Mar 25, 2024 6:33 pm
- Forum: HSSFR4
- Topic: HSSF how can format cell with currency "$"
- Replies: 15
- Views: 2726
- Mon Mar 25, 2024 6:29 pm
- Forum: RPG IV
- Topic: Converting Hundred Year Date Plus Time to Timestamp
- Replies: 6
- Views: 2132
Re: Converting Hundred Year Date Plus Time to Timestamp
From the first post in the thread: ... and a 5 digit time field (HHMMSS) ... From the most recent post: It does not contain HHMMSS. It's just a number. . . . 100 YR TRANS DATE TRANS. TIME 42,109 170,931 42,109 171,058 . . . I'm very confused. You have told us both that it does and doesn't contain an...
- Sat Mar 23, 2024 5:57 am
- Forum: HSSFR4
- Topic: HSSF how can format cell with currency "$"
- Replies: 15
- Views: 2726
Re: HSSF how can format cell with currency "$"
I don't know what you mean by "$ or euro". But when I've done euro, it's been like this: [$€-x-euro2] #,##0.00 For dollar sign it'd be like this: $#,##0.00 Note that you can go into Excel and ask it to format a cell the way you want... then look under "custom" to see what format ...
- Thu Mar 14, 2024 10:52 pm
- Forum: General
- Topic: Trouble exporting text data to pc file in pure ascii (CCSID issue?)
- Replies: 1
- Views: 675
Re: Trouble exporting text data to pc file in pure ascii (CCSID issue?)
Which ASCII is the "pure" one? The term ASCII refers to many, many different character encodings. It's a whole category, not a specific one. And why would you still be using ASCII in 2024? I know of just about nothing that still uses ASCII... it's all been replaced by Unicode. Are you cert...
- Fri Mar 08, 2024 7:59 am
- Forum: HSSFR4
- Topic: Where can I find SK's Articles formerly on System iNetwork?
- Replies: 3
- Views: 588
Re: Where can I find SK's Articles formerly on System iNetwork?
They are the property of Penton Media, so I can't legally repost them. Penton has chosen to take them offline, which is out of my control. You can try to find them on Archive.org, as you mentioned... this has worked for most people.
- Thu Mar 07, 2024 11:08 pm
- Forum: General
- Topic: Configuration Kyocera MA 3005 (color)
- Replies: 1
- Views: 656
Re: Configuration Kyocera MA 3005 (color)
CPF3397 text says "See the job log of the writer". Did you do that? What did you learn? Last time I researched it, Host Print Transform did not support color overlays. Did that change? (This wouldn't cause the writer to end, but if it worked, the overlay would be black & white) You ha...
Re: HTTPAPI
If you don't agree, then I will be forced to go with GETURI (acommodates OAuth token key). No choice .. HTTPAPI does NOT ! This is factually incorrect. HTTPAPI and GETURI do exactly the same thing. If my choice is between writing the code for you for free vs. having you purchase Brad's product, and...
- Thu Mar 07, 2024 6:26 am
- Forum: RPG IV
- Topic: I have a requirement to produce PDFs with large print and I am having issues, need help
- Replies: 4
- Views: 842
Re: I have a requirement to produce PDFs with large print and I am having issues, need help
I've used PDFLIB -- they make it for all platforms, including IBM i, and it works very nicely. They provide documentation of how to make PDFs natively from ILE languages such as RPG. So instead of doing weird things like creating an AFP, converting it to TIFF and converting it to PDF, you can just c...
- Thu Mar 07, 2024 6:16 am
- Forum: General
- Topic: Batch CL for sFTP with Password Authentication
- Replies: 5
- Views: 885
Re: Batch CL for sFTP with Password Authentication
The $ character has a special meaning in a shell script, so to put a $ in your SSH_ASKPASS script you would need to escape it properly.
- Wed Mar 06, 2024 6:18 am
- Forum: YAJL-ILE
- Topic: DATA-GEN \n and \"
- Replies: 6
- Views: 1131
Re: DATA-GEN \n and \"
I was thinking about this, and it'd probably be helpful if I explained my analysis in more detail. The reason you'd get a result like the one that simonerotax posted is because you had a program like this one: ctl-opt option(*srcstmt); dcl-s theResult varchar(1000); dcl-c LF x'25'; dcl-ds data quali...