DSXchange

Yes I involved official support and they are working on it. Will update here once we are able to fix it. Thanks for your time

Thanks for the reply Chulett. This is a legacy code which is coming from years (from 7.5.2 days) which contains DRS plugins all over the code and almost present in every job .The reason they used DRS plugin at that time was to use the same jobs with any DataBase (Oracle, DB2, SQL Server) by simply c...

We are using DRS plugin in our DataStage 11.3.1 jobs to connect to Oracle databases with odbc DSNs. These jobs are working fine with Oracle 12.1 version. But when we upgrade to Oracle 12.2 version these jobs are aborting with "ORA-28040: No matching authentication protocol" error. As per t...

Hi Franklin
resolved it using seq file stage to read the cff file and had one column in metadata which was Binary SQL type and the total length of the record.


thanks!

Thanks for your reply Franklin. I am creating a complex flat file ( writing to a CFF stage, got the copybook details from mainframe team). Having trouble in the new job where I am trying to read it using CFF stage and ftp it. From the link you posted it tells on how to read it using ftp stage from o...

Hi All, As part of my job design, I have created a CFF file xyz.cff (Binary) Now this file needs to be FTPed over to the mainframe box. Typically the ftp job would have a sequential file stage and then a ftp stage. In this case should I 1) Use Complex Flat File stage to read and then use the ftp sta...

I would like to know is there a way to find where is Project directory using Unix command line option, i need know this to use this path in a shell script.

When I am (fresh) installing DataStage 7.5.2 on Unix-AIX box, getting warning as:

Starting NLS installation in project Template
****Could not locate NLS map .
National Language Support has been disabled.
Verb "DS.CONFIGNLS" is not in your VOC

Could someone please help me...

Yes Ray, and the install gets to 44% and then doesn't' t move forward. Then hit the cancel button and then choose to continue the install and the error is thrown. This can move forward but it takes a couple of reboots to get it installed. I was also looking at your post some time back at http://osdi...

Hi, Getting intermittent error "Unable to Create or Attach the Printer Segment" during installation of DataStage 7.5.3 Server on Windows. This is killing the install. Any idea what causes this? I did search for "Printer Segment" but could not find any error close to this durig in...

Thanks guys, the tables have different metadata and approx 95 tables, if in EE we could have used RCP I guess.

So writing a job with 100 extrats or different jobs is the only option?

Hi, I have to extract multiple tables record and write into the different CSV files. Extraction is simple (Select * from table),In Server Edition do you have idea of writing code in DS where we will define the table name , Connection strings of DB and get extracted the record in CSV with Table Defin...

Hi Ray,

Got it to work, if pased from teh transformer as parameter it was not working, now I select it in the source from dual table and it works !

Thanks

Hi All, Posting it here as its the appropriate thread. I need to delete specific data from Hashed File, so my design looks like DRS(Dummy)-----Xfm (Get Key as param)---UV Stage In the UV stage the SQL for userd efined is DELETE FROM LOG_HF WHERE (Key = ?); The job finishes without warnings but the d...