About NitinDwivedi

NitinDwivedi · ‎10-19-2015

Hi, I am using this procedure to insert a record into my DB2 table. The issue is that I am getting cutoff date when the row gets updated in DB2, whereas I am passing date from SAS dataset and Current timestamp. VERS_NR 2,801 VERS_DATO 01.01.1960 VERS_CLIENT_ID 301 VERS_TYPE LOAD_CST VERS_TS 1960-01-01-00.00.00.253692 Please let me know why it is happening and how to sort out the issue. Output from SAS Dataset : VTYPE VERSNR VDATO VCLIENT VTS LOAD_CST 2801 21331 301 1760887609 Excerpt from Code : proc db2util data=abcd SSID=db0t table=systemf.tbcrvers function=i; mapto VERSNR = VERS_NR VDATO = VERS_DATO VCLIENT = VERS_CLIENT_ID VTYPE = VERS_TYPE VTS = VERS_TS; update; run;

NitinDwivedi · ‎03-20-2015

Thanks Patrick. Your hint helped me to resolve the issue. Actually I am new to SAS, therefore small things are quite big for me. I had not thought of using SQL at all and was looking from SET/merge perspective, though there may be solution in that way too, but I was struggling to find the solution. PROC SQL; CREATE TABLE ABCD AS SELECT * FROM ABC, XYZ WHERE ABC.A = XYZ.A; QUIT; PROC SORT DATA=ABCD NODUPKEY; BY LR B; RUN;

NitinDwivedi · ‎03-20-2015

Hi, Need help. I have 2 input datasets having following data. Input dataset _1 area rating 1 0 1 1 1 2 1 3 1 4 1 5 2 0 2 1 2 2 2 3 2 4 2 5 Input Dataset -2 Area User-Id 1 G1 1 G2 2 G3 2 G4 2 G5 Output dataset need to have data in following way OUTPUT DATASET area user-id rating 1 G1 0 1 G1 1 1 G1 2 1 G1 3 1 G1 4 1 G1 5 1 G2 0 1 G2 1 1 G2 2 1 G2 3 1 G2 4 1 G2 5 2 G3 0 2 G3 1 2 G3 2 2 G3 3 2 G3 4 2 G3 5 and so on.. Thanks in advance. Regards, Nitin

NitinDwivedi · ‎07-16-2014

Thanks Jaap, Your help is well appreciated. Yeah it seems incompatablities issue and nothing can be done on this, SAS doesn't support this XML data-type and now need to look around for other solution.

NitinDwivedi · ‎07-15-2014

Jaap, It is exactly the same question asked by ABCD123,not hijacked Also It is a ‘SAS interface to db2 variable problem, not a db2 problem as such.

NitinDwivedi · ‎07-14-2014

Kurt, It is needed for online execution

NitinDwivedi · ‎07-14-2014

Jaap, Thanks. Yes, the issue is data incompablity and I am not sure how can I fix this issue. Right now , not aware about SQL explicit pass through for getting the data.

NitinDwivedi · ‎07-14-2014

Hi , My PROC SQL is working fine for other columns but while trying to fetch column containing XML data, getting following error. SQL is executing in Z/OS environment. DB2 ERROR: RESULT OF SQL STATEMENT: DSN00804E AN ERROR WAS FOUND IN THE APPLICATION PROGRAM INPUT PARAMETERS FOR THE SQL STATEMENT, REASON 16 A DUMP OF THE SQLCA FOR THE GET DIAGNOSTICS REQUEST FOLLOWS: ROW NUMBER: 0 ERROR CONDITION: 1 REASON CODE: 16 SQLCODE: -804 SQLSTATE: 07002 SQLERRP: DSNXROHB SQL query is as follows : PROC SQL NOPRINT; CONNECT TO DB2 (SSID=DB0T); CREATE TABLE FBLM AS SELECT * FROM CONNECTION TO DB2( SELECT CREDIT_ASSESSMENT_SUBMISSION as CAS FROM SYSTEMF.CREDIT_CASE WHERE CREDIT_CASE_ID = '001234bc-4e38-4dee-ad5d-b0e2d91457e8' ); QUIT; Can one guide me that why there is an issue and how it can be resolved.

NitinDwivedi · ‎07-14-2014

Hi , I am facing similar problem, Can you tell me what were the steps taken to achieve. Please explain what eact term signify marked in bold libname db2 datasrc = vagerdb2 user = 'hxf' password = "A2b56" schema='SALES_INFO';

NitinDwivedi · ‎07-07-2014

Hi , DBA has set up the connection and I was able to retreive SQL extract from AIX database thru batch, DBA has generated a new plan to access the view defined in Z/OS. Now I am getting issue while accessing it thru online module. SAS has default PLAN attached, therefore giving SQL -805, Can I change the plan for this view only in Online program, as I have lot many other tables called from the same online program. Please let me know how it could be established.code will helpful

NitinDwivedi · ‎06-26-2014

Hi Jaap, Yes, getting in touch with my Mainframe DBA to establish connection with DB2 table defined in AIX and create view/alias in Z/OS. Is it a feasable approach of creating views in Z/OS and I may access the view using SAS in Z/OS environment.

NitinDwivedi · ‎06-26-2014

Thanks , I will try to reach Mainframe DBA and ask tech support, will get back with relevant findings.

NitinDwivedi · ‎06-25-2014

Hi, No, SAS is not available on the AIX system, It is on Z/OS. I have SAS/Access to DB2 in Z/OS system as i have referenced DB2 tables in Z/OS, not sure about SAS/connect.

NitinDwivedi · ‎06-25-2014

aameHi , I have a requirement where I need to access DB2 in AIX, whereas SAS code is in mainframe environment, Please anyone can guide me what need to be done to establish connection and get data . Document reference or solution to the problem would be helpful. Regards, Nitin Dwivedi

NitinDwivedi · ‎06-25-2014

Hi, I have got the solution , refer SAS format and informat reference document for that, To convert date parameter received from jcl, Execdate=put(input(substr(param),ddmmyy10.),ddmmyyp10.) ; and in where clause need 's' in defining month. Where B + 1 Months > exec_date and B <= exec_date

Online Status	Offline
Date Last Visited	‎04-08-2019 07:54 PM

PROC DB2UTIL, Issue while Insert

Re: Combining data

Combining data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: Connection to DB2 in AIX, whereas my sas program in Mainframe/ZOS

Re: Combining data

Re: proc sql query to extract value out of xml data

PROC DB2UTIL, Issue while Insert

Re: Combining data

Combining data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: proc sql query to extract value out of xml data

Re: Connection to DB2 in AIX, whereas my sas program in Mainframe/ZOS

Re: Connection to DB2 in AIX, whereas my sas program in Mainframe/ZOS

Re: Connection to DB2 in AIX, whereas my sas program in Mainframe/ZOS

Re: Connection to DB2 in AIX, whereas my sas program in Mainframe/ZOS

Connection to DB2 in AIX, whereas my sas program in Mainframe/ZOS

Re: Accessing DB2 table with search key DATE field