Author |
Message |
Topic: Converting hex values to decimal |
misi01
Replies: 3
Views: 767
|
Forum: Database Posted: Thu Jul 11, 2024 12:03 am Subject: Converting hex values to decimal |
I didn't forget, but maybe you misunderstood my question?
The original post and this one can be simply illustrated with the following Rexx script.
str_b = 'F1F2F3'
say str_b' 'x2c(st ... |
Topic: Converting hex values to decimal |
misi01
Replies: 3
Views: 767
|
Forum: Database Posted: Mon Jul 08, 2024 7:25 am Subject: Converting hex values to decimal |
This seems strange to me and I must be missing something that's ridiculously simple, but for the life of me, I can't find it.
select hex(24) from sysibm.sysdummy1 ;
shows the hex valu ... |
Topic: English expression |
misi01
Replies: 1
Views: 531
|
Forum: Related Non-Technical Topics Posted: Wed Jul 03, 2024 1:42 am Subject: English expression |
A colleague asked me (I who haven't lived in England in decades and has worked all my life in Sweden) what the English expression might be for the concept of masking and copying data from production t ... |
Topic: Displaying binary data as "readable" such |
misi01
Replies: 2
Views: 979
|
Forum: Database Posted: Mon Jun 17, 2024 7:46 am Subject: Displaying binary data as "readable" such |
Thank you for your suggestions. I'll almost certainly revisit the CASE example for the situation where the database can contain negative values (very unusual), but for all the "ordinary" pos ... |
Topic: Displaying binary data as "readable" such |
misi01
Replies: 2
Views: 979
|
Forum: Database Posted: Thu May 16, 2024 5:04 am Subject: Displaying binary data as "readable" such |
I'm selecting data from a DB2 table that contains 2 binary fields. These fields (in reality) contain the equivalent of a DL/1 segment, so they can easily contain a mixture of character and COMP-3 fiel ... |
Topic: COBOL and SQL IS BINARY DB2 column |
misi01
Replies: 3
Views: 1044
|
Forum: Application Programming Posted: Mon May 13, 2024 6:21 am Subject: COBOL and SQL IS BINARY DB2 column |
The actual content of the binary fields is only used as a sort of placeholder.
The actual s/w package is intended to mask things like SSN values so they can't be tied to a "real" person.W ... |
Topic: COBOL and SQL IS BINARY DB2 column |
misi01
Replies: 3
Views: 1044
|
Forum: Application Programming Posted: Tue May 07, 2024 2:37 am Subject: COBOL and SQL IS BINARY DB2 column |
I'll answer my own question in case anyone else has the same problem (a colleague helped me).
The following can insert a row into a table
insert into TDRT3C0
values( 0 -- LOG_NR_ORDER
,0 ... |
Topic: COBOL and SQL IS BINARY DB2 column |
misi01
Replies: 3
Views: 1044
|
Forum: Application Programming Posted: Tue May 07, 2024 1:23 am Subject: COBOL and SQL IS BINARY DB2 column |
We have a DB2 table defined with a column defined as Binary (yes, completely new for me as well).
When the copybook is generated the resulting DB2 definition is
,DL1_SEGMENT BI ... |
Topic: Pros and cons of name-Value pair tables in DB2 |
misi01
Replies: 3
Views: 2636
|
Forum: Database Posted: Fri Mar 22, 2024 2:56 am Subject: Pros and cons of name-Value pair tables in DB2 |
So, reading 4 rows instead of 1, or did I misunderstand you?
To say it sounds inefficient must be an understatement.
How many times per day will it be read? |
Topic: Compiling Rexx scripts |
misi01
Replies: 10
Views: 2293
|
Forum: TSO and ISPF Posted: Sat Mar 02, 2024 3:02 am Subject: Compiling Rexx scripts |
I think you missed the bit where I wrote
as long as you don't try to actually use it
Not sure if want to compile the code using the NOCOMPILE option you mentioned.
I'm quite happy to see duplicat ... |
Topic: Compiling Rexx scripts |
misi01
Replies: 10
Views: 2293
|
Forum: TSO and ISPF Posted: Thu Feb 15, 2024 5:20 am Subject: Keeping your Rexx source/CEXEC libraries in synch |
The idea (?) behind compiled Rexx is to be able to distribute your code as object code only while "protecting" your source code from prying eyes.
One of the problems you're going to run int ... |
Topic: Compiling Rexx scripts |
misi01
Replies: 10
Views: 2293
|
Forum: TSO and ISPF Posted: Thu Feb 15, 2024 5:02 am Subject: Compiling Rexx scripts |
Thought I'd update this thread a bit more.
One of the "quirks" of the Rexx compiler (CREXX) is the fact that it is less "forgiving" than the interpretative variation (IREXX) (whic ... |
Topic: Compiling Rexx scripts |
misi01
Replies: 10
Views: 2293
|
Forum: TSO and ISPF Posted: Fri Feb 09, 2024 4:39 am Subject: Experiences of compiling Rexx code. |
After reading the documentation, it was actually easier than I thought.
The stripped down PROC I created was the same as that defined at
https://www.ibm.com/docs/en/zos/3.1.0?topic=by-rexxc-fan ... |
Topic: Compiling Rexx scripts |
misi01
Replies: 10
Views: 2293
|
Forum: TSO and ISPF Posted: Thu Feb 08, 2024 7:06 am Subject: Cannot preview append |
I was going to append a long description of how my attempts went compiling Rexx scripts, but the preview button is still failing. |
Topic: Compiling Rexx scripts |
misi01
Replies: 10
Views: 2293
|
Forum: TSO and ISPF Posted: Tue Feb 06, 2024 8:46 am Subject: Compiling Rexx scripts |
Thank you.
Lot to read and, I imagine, many pitfalls along the way
Still, simply a matter of reading up, experimenting and taking notes of what to do to get it all working. |
|