DSXchange

HI,
Can any one throw light on system variables (@inrownum, @outrownum,@true,@false).Can we use them in transformer stage to get rowcount of specified links?

Thanks..

Oh.Ok..
Thanks

Craig, did you mean Runtime column propagation? I didnt get what RTI/SOA job means?


Thanks..

We are loading records from a sequential file to database.The database target table is empty.Even though we sent 1 record from sequential file, we are getting the same error.

Thanks..

Hi all, We are unable to load records in database, the error message we are getting is APT_CombinedOperatorController(0),3: [IBM][CLI Driver][DB2/AIX64] SQL0803N One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the...

The link specified by Craig is good with all information..

Thanks

Thanks Ray for pointing that..

Hi all, Didnt get any answer from IBM regarding that surrogate key error. I am wondering whether is it related to some APT_PM environmental variable? Why because i am getting this error everytime i get surrogate key error main_program: APT_PMsectionLeader(3, node3), player 4 - Unexpected exit status...

Hi all,
The issue solved.In DS v8.0.1, when we check the option catch operational meta data in DS ADMINISTRATOR, When ever a job runs, operational meta data is stored in xml files.We can access those XML files.It got all information related job run..

Thanks for all responses.

Thanks for all the replies.I tried with pipe delimited between two commands and it worked.

Thanks

Thanks Ray, I will refer the document..Will post if any doubt..

Thanks

HI all, I have one xml file.I want to write that xml file in a sequential file, with some columns eliminated. I never used XML stages.There are 3 xml stages XML input, XML output and XML transformer. Can anybody help me What stages should i use? I tried XML input and XML output stages, as i open the...

Thanks for the clarification..Really this DSXchange is helping a lot..

Thanks Brian..But i want to know as key is created on a column, is it indexed as well? or should we explicitly create an index on that key column.

Thanks

Hi,
I got small doubt.If a key is specified on a column, Does it mean that it is indexed as a default? And if we create index on a column, does it mean that its a key?
I appreciate any clarifications..
Thanks