DSXchange

The error is just pointing to the compiled code. ##W IIS-DSEE-TBLD-00000 10:04:31(009) <main_program> Error when checking composite operator: Output from subprocess: "/projects/ETL/PSA/RT_BP3232.O/V134S22_TEST3_Trans_EXC_DESC.C", line 714.147: 1540-0063 (S) The text ";" is unexpe...

Hi This is on V 8.5 The below derivation throws compilation error If svrEarlyStartNullInd=0 AND (MidnightSecondsFromTime(TimestampToTime(LkOutTo_LkUp_Loc.TGT_WRKD_ST_TIME)) < MidnightSecondsFromTime(TimestampToTime(LkOutTo_LkUp_Loc.TGT_MIN_SHFT_ST_TI))) Then 'Early Start' Else 'T' However the below ...

Hi, Below is the steps i am following to build a shared library parallel routine. 1. Created libpadcharPX.cpp code as below #include<iostream.h> #include<string> #include<string.h> using namespace std; char *PadcharPX(char *str,char *padchr,int lenstr,char *align){ int i; char *padstr; string str1; ...

The documentation of source code for dsjob was found in Server job developer guide of version 7.5

... and is listed in one of the manuals. So is the source code for dsjob described in one of the manuals ? Could you please share in which manual as the only reference I have seen is description of dsjob under API chapter which doesnot specify from where (universe or XMETA) the link counts are fetc...

Hi Below is a part of .odbc.ini 55 [Informix] 56 Driver=/apps/ETL/IS/8.5/Server/branded_odbc/lib/VMinf24.so 57 Description=DataDirect Informix driver 58 Database=db 59 LogonID=uid 60 Password=pwd 61 ServerName=informixserver 62 HostName=informixhost 63 Service=online 64 Protocol=onsoctcp 65 EnableIn...

Could you please help in understanding if the dsjob -linkinfo picks the count from RT_STATUSnnn or XMETA ?

Surprise surprise, I was thinking @RECORD fetches all columns from the table but it looks like @ID is not included in @RECORD.

Thanks Ray, Now I can easy identify the link counts in RT_STATUSnnn after including @ID.

What gets me confused is the select statements are the same except First query: EVAL DS_JOBOBJECTS."CONVERT(\@FM:@SM:@VM:@TM\,'$#!',@RECORD)" AS DUMMY1 FMT '1000L' Second Query: EVAL DS_JOBS."CONVERT(\@FM:@SM:@VM:@TM\,'$#!',@RECORD)" AS DUMMY1 FMT '1000L' First one runs but secon...

chulett wrote:FYI - Code tags do not allow bold so I changed you to quote tags which do.

Thanks Craig

The isx taken from V8.5 has two files
<Jobname>.pjb
Is_manifesh.mf

The pjb file has job information in XML format, tried importing the extracted pjb file but it failed to read the pjb export.

Scanned the RT_STATUSnnn for a specific job and found entries where the link count, link start and end times are captured, sample record (RT_STATUSnnn.@RECORD) shown below "STAGE$2$2013-03-08 06:14:46$2013-03-08 06:14:59$45678592$ 5699 $$$$$12.5$$$$0$25$2" The one in bold is the link count...

Hi I have run the below query and it runs perfectly fine with no errors SELECT DS_JOBS.NAME AS JOB_NAME, DS_JOBS.CATEGORY, DS_JOBOBJECTS.NAME AS OBJECT_NAME, DS_JOBOBJECTS.OLETYPE, EVAL DS_JOBOBJECTS."IF INDEX(@RECORD,'ABC',1) = 0 THEN '0' ELSE 'FOUND' " AS REC, EVAL DS_JOBOBJECTS."IF...

Thanks Ray, Could you please share which of the RT tables has the count stored

Hi I was trying to find in which record and field of DS_JOBOBJECTS the link counts are stored. The issue is with multi-instance jobs where dsjob -linkinfo is returning counts of another instance run. This is happening rarely but is happening. If some one has faced this issue please guide the resolut...