DSXchange

Do you mean to say it skips the jobs or JobSequence which are in aborted state, when you restart
Could you explain on, which job/JobSeq got aborted and which one got skipped?

svcon=TrimF(TrimB(DecimalToString(DSLink3.MSBDAY,"suppress_zero"))) var5=If Len(svconv)=6 Then 19:svconv Else If Len(svconv)=7 Then 20:Right(svconv,6) Else "0" If var5<>"0" Then StringToTimestamp(var5[1,4]:"-":var5[5,2]:"-":var5[7,2] : " 00:00:00","%yyyy-%mm-%dd %hh:%nn:%ss") Else "0" Was it all fr...

I was wondering if that appeared latest version (ver and hence asked for the same.

The data sets input to the Join stage must be key partitioned and sorted. You might have noticed this in document. So if you Joining key is Col1 and if you do a partition on Col2, it wont help you.

What is the version that you are using?

What is your job design? Wrong partition will screw up the number of records that been passed. Are the both stream well partitioned on the key (as you mentioned 'Hash')?

Hi Rick, As you are awaiting response from IBM, as a workaround, why cant you export the job with "Job Executable" option that available in Manager? Which will include the job with its compiled code. So you dont need to recompile at QA or Production or whaterver. As you can do the rest of the stuff ...

I dont have access to PX now. I am expecting that there should be a option if you tweak the data type defaults of that field, which I already said. BTW: Why do you need to convert it into Time data type, why can you keep as varchar as is. Since many version including some earliar version of database...

Very recently we had discussion on that. Kim had posted such code SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'DATABASE_TYPE',1) > 0 then 'FOUND' else ''" AS FOUND ...

There is a Exam 705 : Business Intelligence in IBM. Just clear one. :D

narasimha wrote:

kumar_s wrote:narasimha - Drag drop functionality is not available in Server Merge stage.

Kumar,

I am pretty sure Drag drop functionality exists in Server Merge stage. In fact I double checked it now.

Oh Iam sorry.. then I should be missing it.

So you should have RTI plugings as well.

As KenMentioned, generated SQL will use To_Date function automatically, which will avoid these conversion errors to appear.

Hi Vijay,
Check for the filename and path name. Copy and type for the same value that you had given in the link information.
narasimha - Drag drop functionality is not available in Server Merge stage.

So ODBC should be having the Nullable option for that address2 field as NO. Since you are delibreatly providing Null Values, mark it as Nullable = 'Yes'