DSXchange

Hi, I am facing one issue with Dataset. I have a job which reads from DB2 table and loads to a Dataset and the second job uses that dataset as a lookup and loads into a file. When these jobs run through a sequencer, the first jobs runs with no issues and the second job aborts with the below error. D...

Hi, I am reading a DB2 table and its a simple select statement with a where clause and writing to a Dataset SELECT PART_ID, SYSTEM_ID, TYPE_ID, EFFECTIVE_DT FROM #jp_SCHEMA#.HUB WHERE TYPE_ID #jp_LIST# FOR READ ONLY WITH UR Its a multi instance job. This job ran fine with one instance and failed for...

Hi,

I am writing a routine and I need to fetch only a few number of jobs rather than fetching all the jobs in the project.

Right now I am using DSGetProjectInfo(DSJ.JOBLIST) to get all the jobs, but is there a way to get only few jobs on PAttern matching.

chulett wrote:Please don't post your questions in multiple forums and please try to pick the right one to post in.

Are you looking for some way to return only a subset of jobs from the function or some way to fi ...

HI Chullet, Sorry for that. I accidentally posted in server.

Yes I need only a subset of jobs.

Hi, I am writing a routine to get the run time stats of a job. I need a list of jobs on a particular pattern rather than getting all the jobs. For all the jobs we use DSGetProjectInfo(DSJ.JOBLIST) Can some one help me how to get a list of jobs with a pattern. For example If i have different jobs wit...

arvind_ds wrote:Use execute command activity in the job sequence to read the file.Store the value into a variable activity stage and then pass that value to the subsequent job in your workflow.

Let me try it. Thanks a lot for your quick response

Hi, I have a requirement to read the max month end date from the target and accordingly i need to put the data from source. For eg: In the target if I have 2011-09-30 date as the max month end date, then I need to pull only the data where the month end date in the source is greater than 2011-09-30. ...

even tried it in ODBC enterprise still the same error

yeah i tryed ['POOL #']....["POOL #"]....'POOL #'.... "POOL #"....as POOL
nothing works

Tried that but still no luck it shows the same error

select [PMT AMT] as PMT_AMT [POOL #] as POOL ect.... from table_name this is the sample sql i am trying to read data using ODBC from sql server DB but having issue since one of the column is having # . ODBC_GE_MONEY_INPUT,0: ODBC Info: SQLSTATE = 42S22: Native Error Code = 207: Msg = [IBM(DataDirect...

ok Can you tell me how to implement it in transformer.

ray.wurlod wrote:Welcome aboard.

Are the data partitioned on the "key used to determine duplicates"?

i am partitioning on the key columns in the sort before remove duplicates.

i have a job which is currently runing fine with 1X but having problem then i change it into 2X , have a sort followed by remove duplicates. Data is hash partitioned in sort based on key columns the data type fr both of the is integer. The remove duplicates when using 1X is removing 148 rows but if ...