Search results for query: *

Hello ... I'm not sure if I'm posting this question in the correct forum, if not, please let me know. I'm hoping someone has some experience with the DSQEC_LAST_RUN global variable. I read this variable controls the updating of the LAST_USED column in Q.OBJECT_DIRECTORY. Our installation has...

Hi everyone. I would like some advice on how to read in raw data where each record has multiple fields in which the delimiter used to start the string is different than the delimiter used to identify the end. The backwards apostrophe (`) is used to indicate the beginning of the value and a...

I’m not sure how best to describe what I’m looking for so apologies in advance if I’m not clear. I’m trying to come up with a solution to create as instream sequence number set as a source for comparison. We have a table where we store a four-digit number that has been assigned to a customer...

Hi everyone ... I am having an issue with the century portion of a date. I am reading in a date value of YYMMDD using a YYMMDD6 informat. An example is 130113 for January 13, 2013. When I write the value out in my put statement with a format of YYMMDD10, I'm getting the value 1913-01-13...

Hi everyone ... I'm hoping you guys can offer some guidance. My update query doesn't seem to work. I'm using QMF to interact with DB2 v9 on z/OS. I typically stick to select statements so I'm a bit out of my element. Here is what I've got: UPDATE TABLE1 A INNER JOIN TABLE2...

Hello ... I hope someone can help me on this. I have a table that lists customers and the books they have purchased tne the language they purchased that book in. I have three requirements and what I thought was an easy task is turning out not to be so easy. Here is the way I originally...

Hello ... I'm looking for some advice on how to handle the following task. I’m trying to get a value to display if the original value is NULL. Here is my SQL: CASE (B.USR_R_NM) WHEN X'60'...

I’m having some problems writing out a timestamp field. The format that I was aiming for was YYYY-MM-DD-HH:MM:SS.ssssss. The informat used to read in the data was TODSTAMP4.. Here are some samples of my output using a PUT statement: NO FORMAT DATETIME23.6 TIME12...

Hello … I hope I am posting to the right forum and someone here can help. I am trying to block a VB data set to FB, but the JCL I’m using (using both DFSORT and File-AID), but neither seems to perform the function I am looking for. My input file is a variable length data set where the data...

Hi everyone ... I was curious, does anyone know if it is possible to store SAS source code in compiled form as to protect the original source from disclosure or tampering with? Thank you.

Hello … I am trying to understand how to use the IF statement in my SELECT statement. I will be unioning three queries together, each are pretty much the same but the WHERE clauses have a few differences. The type of data I am querying may identify both “error” and “warning” message types...

Hello everyone … I need some assistance in determining how to read input record. Normally, I just start at a specific position and begin reading in until the end of the value. However, I’ve come across a flat file that has some unique characteristics and am hoping someone can suggest...

Hello - I would like to ask for advice on how to accomplish a task. I have a file that lists account numbers in sequential order. There are approximately 70,000,000 records in this file and it is produced weekly. I often receive requests to fetch account numbers where I know what the first...

Hi everyone … I know almost 0% about REXX, but am using an exec written about 16 years ago by a predecessor at my shop. The function of the exec is used in a batch job to send data in a file created by a previous step in the same job to an SMTP gateway on one of the MVS communication server...

Hi everyone ... I hope I am posting to the correct forum. Please let me know if not. I am running QMF V8R1 on an z/OS platform running DB2. I am trying to pass a JCL parm to QMF using QMF batch. In my SQL, I have an IN operator like the following: WHERE VERS_NUM IN (&VERS_NUM) I am trying...

Hi everyone ... I would appreciate some input on the best way to accomplish my objective. Here is a bit about my situation. Our shop runs SAS version 9.1 on z/OS. I have an 80-byte raw data set which contains anywhere from 60,000,000 to 70,000,000 records. This raw data set is a list of...

Hello ... I am trying to read a raw data file. Here is a sample of my data: 240010002799XXXX8.%0910090928241910000000000000000704030318507040303185231755 240010300000XXXX8.%9999999999943410000000000000001208070734212080707342165858 240010300000XXXX6.%99999999999054...

Hi everyone … I need some help with my SAS program. I am getting some unexpected results in my ouput and I am not sure where to go to resolve them. I run this via batch JCL on a mainframe running z/OS. Here is my program: OPTIONS; DATA R001 (KEEP= ISSUENUM...

Hi everyone ... I'd like to ask what I think is simple. I'm still learning SAS and am trying to clean up some "wordy" code. I'm looking for input from others on way that I can go about the same thing, but more efficiently. For example, here is a simple If-Then/Else. My objective; I'm...

Hi everyone … I’d like to ask if anyone knows or can suggest any SAS functions for working with and manipulating datetime values and time zones. I’m using SAS 9.1 running on z/OS. I will try to explain my objective. I have seven separate SAS data sets for each day of the week and each SAS...