DSXchange

Hi Guys, I need to group the xml tags based on prdname and ccy columns. I tested by giving the trigger column - prdname. The accounts tag will be closed and new tag is opened only when the prdname changes. If the prdname is same for the next record the data will be in the same accounts tag. Now my r...

I am generating an XML file. The requirement is when Prdname and ccy col changes we need to have <accounts> tag opened and closed for new combination. So in order to achieve this if I am giving the trigger column as prdname, then i am getting the following output: <accounts> <datarow> <prdcode>CABIP...

hi, i have job where i extract data from db2 table and populate to a sequential file. each field value is delimited with pipe & my last filed is a decimal field. am getting juck value for the last field but the job completes(finshes) sucessfully, but job which take this sequential file as source...

I have a similar problem.Am using Datastage Server V8.0 . Even if I login as admin, am not able to delete the routine from designer.

Is it not like, when I disconnect a session from webconsole all jobs assosciated with that session will get released?For eg,I have 2 jobs open in a session, I have made changes to both the jobs but not saved.When I give view data on one job,its struck over there.In this case I would like to kill tha...

When I checked XMETALOCKINFO table , I find that -If a user has opened 3 jobs in a session there are 3 rows against that user id,session_id with unique values for "Repository_ID" and "Locked_At" . If I want to release one particular job,How to find which row points to which job?

The Locked job is not getting listed when i execute LIST.READU from administrator or datastage prompt.It is not showing up under
"clean up resources" in director also.Tried clearing RTLOG file of the locked job,but its not releasing the lock.Is there any other way to get it unlocked?

UtilityFatalToLog was not available.I tried with UtilityAbortToLog.But it didn't help.It was like ExceptionHAndler --->Notification --->UtilityAbortToLog. But the sequencer didn't send any mail when it stopped. The message given as input param for UtilityAbortToLog was not there in the log. I think ...

How to convert Signed Decimal to EBCDIC in datastage?

eg : -123.44 (convert to EBCDIC form)
-123 (Conver to EBCDIC Form)

Please help me out is ther any datastage built in function or do we need to write Routine? if so please give some clue?

Thanks in advance...

Thanks
Harish

Hi Craig, we cann't use CFF stage in the target stage. It can only be used as the source stage and i need to convert ascii data to MF data. I got to know that Ebcdic() function cann't be used to convert signed integer and signed decimal to MF code.Please help me if any routine or code has to be writ...

Hi All, Iam using ebcdic() function to convert the below input data's from Ascii to Ebcdic format, but the function is not converting the data as required. Iam passing the input data ebcdic(sign&Deci data) this throws data truncation warning in spite of givign datalength as 7.And for ebcdic(sign...

The wait for file is to abort the sequencer if the file didn't arrive within the time out period and trigger the exception handler .But once we receive the file we will just restart the sequencer so that it checks for the file and triggers the jobs that follow the Wait for file activity.

I have a sequencer which in turn calls 5 other sequencers,few routine activity stages,User variable stage and wait for file activity. all four options namely Add checkpoints,Automatically handle activities that fail,Log warnings,Log report messages after each job run is checked in the main sequencer...

I am also facing the same issue... the nVL is not working for me..
In the unix, the input command just logs me in but doesnt execute the sql as nVL is not working...

Please can u tell me the resolution for this

Hi ,

Even i need to access the teradata database using my routine. Please can u tell me how to achieve this.