DSXchange

Hi, I'm bit curious abt the limitations of Java Pack. Say for ex i have to process 10 million records or more through Java Client Stage or Transformer stage,does it handle. The reason why i'm asking is Web Services cant handle more than 10000 records,usually we see lot of errors like heap size or me...

I try to run job from command line with the following commad: $DSHOME/bin/dsjob -run -mode NORMAL -param "CLIENT_ID=$client_id" $PROJECT $DSJOB But job is aborting with this error Issuing abort after 50 warnings logged. But when i run the same job from director it runs sucessfully. And in ...

How can i ignore partition level in dsjob -report..
Can you please post the new ETLSTATS functionality for px jobs..
And also where can i found vincent logic..
Thanks,

If i agreagte,then my counts wont match at all in my case...
I know lot of folks might be using ETLSTATS functionality which is given by kim...
If this the case,i'm not sure how ETLSTATS functionality working properly..
Can any one explain...so that i'll modify my ETLSTATS jobs..
Thanks,

Ray,
Here i'm using dsjob - report command..
How can i modify this commad to get DSJ.LINKROWCOUNT as the fourth argument to DSGetLinkInfo(). link count.
Thanks,

Hi, I created a server job and in befor job routine i passing this command /usr/local/Ascential/DataStage/DSEngine/bin/dsjob -report projectname #JobName# XML >#OUTBOUND##JobName#.xml And in the job i'm reading the xml and writing the results to a file. If you look into following xml,i didnt underst...

Ray,
You are rght,there are spaces in data.
When i stip data i see right results.
Thanks,

Hi, I'm trying to convert decimal to string,but i'm not getting right results. Ex 1: Input Value = 123.45(Decimal(3,2)) OutPut = 12345(Varchar) Ex 2 : I/P :001.30 o/p " 00130 Itry the following function,but the function is not processing any rows: Trim(DecimalToString((Fabs ((DSLink2.NOMIN_QTY*...

Ray,
U mean,Job will run successfull with out any fatal errors.
Usually Transformer stage do all type conversions..
I mean does implict conversion will happen with Schema File with out any fata errors.
Thanks,
Har

All, Let me start from here: Scenario 1: Say my Source field datatype is Date(yyyy-mm--dd)(EX:2007-01-10). And if i define meta data in schema file like this date[mm-dd-yyyy](Ex : 01-10-2007),does the data will change automatically or not. Scenario 2: Say my input datatype for one field is Decimal(E...

Ray,
I disable RCP and i try to use schema file and try to compile,but its giving same error i.e no column are not defiend in the stage.
Wat i'm doing here is just trying to read data from sequential file using a schema file and load it to another sequential file.
Any idea wats going on here...

ray,
You are the DS Guru...
Another Qucik question,when ever i use Schema file do i have to enable RCP or not.
In my test job,if i disable RCP then sequential file stage is giving error ,
i.e no column are not defiend in the stage.
With out enabling RCP,can i use schema file for meta data.

Again Same error
Input buffer overrun at field "Clo2", at offset: 7 [impexp/group_comp.C:5548] .
NLS is disable in Environment.

Hi All, I created a small txt file with 2 fields and i created a schema file for this metadata . And i want to read the txt file using schema file with out importing meta data. Here is the Schema file that i created: record (Col1:nullable string[5]; Clo2:nullable string[5]; ) When i use this schema ...

ray,
I check the VOC File for ExecDOS and its not their.
I planning to add the following record to VOC file,can you correct the following record if their any mistakes in it
DSU.ExecDOS
001 V
002 DSU_BP.O/DSU.ExecDOS
003 B
004 BN
009 DSU_BP.O

Thanks,