DSXchange

The Datastage job is having SFTP Stage, connects to Mainframe to extract data from mainframe to Linux. We are using TECTIA to transfer the data. There are many jobs which does the same functionality but everyday there will be few failures and after re-start couple of times , jobs run successfully. E...

Chulett, If encoding="UTF-8" in first line of XML, the data is having issue. If encoding="ISO-8859-1" in first line of XML, The Data between Source and Target are matching. I can't change NLS Settings , as they are disabled in our Project. Is there any function to resolve this is...

Ray,

We don't have ^Z character in the source data.

The Source Data is as below.

<typ:CondoProjectName>‘Foothills Addition</typ:CondoProjectName>

Output in Dataset is as below.

"^ZFoothills Addition"

Please advise me.

We are reading below XML file as below. The Last Column(CondoProjectName) has a special char. <?xml version="1.0" encoding="UTF-8"?> <typ:UCDPReceiveAppraisalRequest xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://receiveappraisal.compan...

Hi All, We could create XML Output files by defining XPath Expressions but i tested for few columns and did it manually and file created successfully. I need help for the following. 1. We might need to create XML File for arround 1000+ columns and is there any different process where XPath Expressio...

Hi All,

We are reading DB2 Table and need to create an XML fi using XML_Output Stage. How to create XSD file using the DB2 Metadata.

Thanks for your Help.

Hi, I designed a job which will read Sequential file and create a XML file using XMLOuptut stage. The output XML file is not getting correct values for Date datatype. 1915-01-01 copied as 5828963-12-20 1975-01-01 copied as 1975-01-01 Please see the below Input and Output Results. Any Date which is l...

1. Get message id from DataStage job log where msg type = STARTED START_ID=`dsjob -logsum -type STARTED ${PROJECTID} ${JOBID} | nawk 'ORS=(FNR%2)?FS:RS' | grep Starting | tail -1 | awk '{print $1 }'` PROJECTID is project name and JOBID is job name 2. Following will give you parameters used dsjob -lo...

I am reading Sequential File of 27000 Records of which 25000 Records MetaData is matching and processing the 25000 records. While Reading Sequential File, We are using Reject mode option and writing Rejected records output to Sequential File.All the Rejected records (arround 2000) are written to Rej...

Try this:
link2.first_name :" ": link2.Last_name

The issue is resolved and DBA mentioned that error involves collection/package DSNASPCC.DSNATBL8. Systems Team was
working on that package and might be due to conflict may
caused that issue.

Hi All, I am getting below error message when i tried to Delelte few records from Table. This Query is being run from past 1 year and no changes to Datastage Jobs and we had no issues. Today we are getting the below error. Please Advice me if you have information. DB2_del_TTABLE_Full,0: Fatal Error:...

This job is running currently in production from long time. The job when re-run its running successfully.

Is it possible to find why that error occurs or someone have got the same issue.

Ray, We want to view Production Log. The users should not execute/modify the Datastage Jobs but only view the log. We have command center and they will schedule the jobs. The jobs are scheduled to run every day after 11:00 PM. As an ETL Developer, I want to view the job log in production without hav...

Hi All, Right now I am having permissions to view logs using Datastage Director and the developers do not have access to view the log. I have permissions to execute the jobs in production. I want to provide all the developers to view the log using their indidual id but should not modify/run the jobs...