DSXchange

I am doing pivoting

input 3 columns
col_1,col_2,col_3
1 0 2


Output ( 2 column s
Pivote

col1 , col2
1,0,
1,2

I am getting Output
1,0
1,2
1,
i.e one extra recrod with blank col 2 generated , is this expected

I am doing export using the following command ./istool export -domain XXXX -u dsadm -p **** -archive dpr_dev.dsx -ds '-base="HOST/dpr_PROJ_dev" Jobs/*/*.*' When I do cat The output dsx file dpr_dev.dsx it is giving output in binary format , instead normal format Query Which format the dsx ...

In a Parellel job to 4 different streams of update, insert and delete records in a table at the same time. IS IT leads dead lock Contstaints Source DB2---------Transformer Conditon1------- DB2 ( TABLE A INSET) --------Conditon2--------------- DB2 ( TABLE A UPDAT) --------Conditon3--------------- DB2...

ray.wurlod wrote:When you get to 8.1 or later, you will be able to use istool (Information Server Manager) for this functionality. It is available server and client side.... ...

Thanks for your information is it the same command used in 8.x server

What is the Equivalent command in Unix OS to take the backup

dscmdexport /H=hostname /U=username /P=password project_name export_file_path [/V]

nagarjuna wrote:Yes , you can compile a compile a job using dscc utility from client box only

Can you please elaborate what exactly the dscc utility

I want to compile job through command line is there any way please let me know

It's actually more difficult in version 8, for example because DS_METADATA (which holds table definitions in earlier versions) now holds only category (folder) "pathnames" - the actual table definitio ... When I am running the following query SELECT * FROM DS_JOBOBJECTS , DS_JOBS WHERE DS...

This SQL statement will return job parameters. Exactly what metadata do you need. You need source and target table names? You need column names too? You need run time metadata like job start and end t ... Thanks for your reply I am expecting the query , which will give the, Table names and its meta...

'Fetch' why, for wwe able to get job parameters using SELECT EVAL DS_JOBOBJECTS."@RECORD<14>" AS Param_Name, EVAL DS_JOBOBJECTS."@RECORD<16>" AS Prompt, EVAL DS_JOBOBJECTS."@RECORD<19>" AS Type, EVAL DS_JOBOBJECTS."@RECORD<17>" AS Default_Value, EVAL DS_JOBOB...

we able to get job parameters using SELECT EVAL DS_JOBOBJECTS."@RECORD<14>" AS Param_Name, EVAL DS_JOBOBJECTS."@RECORD<16>" AS Prompt, EVAL DS_JOBOBJECTS."@RECORD<19>" AS Type, EVAL DS_JOBOBJECTS."@RECORD<17>" AS Default_Value, EVAL DS_JOBOBJECTS."@RECORD...

I want to fetch metadata of any source or target stage

of type db2 or seq file to xls file

Sainath.Srinivasan wrote:...also how big is your job..!!

each job contains 10 to 12 stage

how this info related to my query

Hi All,

I am planning to schedule around 100 jobs in Control M ,
These all are independents jobs.

My questions:

1)Is it recomended to run 100 jobs at one shot.

2) Is there any limitations that we can run N jobs at one shot

miwinter wrote:MSD???

MSD= most significant digits