topic Re: how to use TPT in DS2 data step? in SAS Data Management

how to use TPT in DS2 data step?

Jade_SAS — Tue, 22 Aug 2017 21:20:35 GMT

Hi All,

I got an error when using TPT in DS2 data step, the coding and error are below:

proc ds2;

data TD.TEST(TPT=YES FASTLOAD=YES TPT_MAX_SESSIONS=4);

method run();

set test.data1;

end;

enddata;

run;

ERROR: Compilation error.

ERROR: Syntax error or access violation TPT

ERROR: Unable to execute CREATE TABLE statement for table TD.TEST.

I checked the same DS2 step works without TPT, see coding below:

proc ds2;

data TD.TEST1;

method run();

set test.data1;

end;

enddata;

run;

What's the correct syntax to apply TPT is DS2 step? Thank you!

Jade

Re: how to use TPT in DS2 data step?

kiranv_ — Wed, 23 Aug 2017 00:24:02 GMT

this is very interesting. I have not used proc DS2. can you do try tpt in libname statemnt as something shown below.

libname tera teradata user=testuser pw=testpw TPT=YES;

Re: how to use TPT in DS2 data step?

Jade_SAS — Wed, 23 Aug 2017 13:16:48 GMT

Thank you for the suggestion! Tried to add TPT in the libname statement, then try the coding again, unfortunately still get the same error

Re: how to use TPT in DS2 data step?

kiranv_ — Wed, 23 Aug 2017 13:25:31 GMT

looks like TPT is not compatible with proc ds2. Some one from SAS could tell us more about this . I think you can try just fastload = yes dataset option.

Re: how to use TPT in DS2 data step?

Jade_SAS — Wed, 23 Aug 2017 17:19:47 GMT

Right, I feel the TPT is not compatible with PROC DS2.