DSXchange

Some of the jobs doing ABAP extracts from DataStage have a dump in SAP in ST22. This is during the extract from SAP. So the job is running from 3.08AM and there are 18 mil rows to be pulled. The dump says it has come across a communication error at 5.14. The exact error is Error when opening an RFC ...

Can we do any merge like this automatically? All the Audit.txt into a single Audit.txt? I need to remove the headers and trailers in each file too. This is now being done manually and want to implement an automated way either using any shell script or Perl or Nant as we use Nant. The files are appea...

This is what I understood - Use stage variables to construct the line "Credit Family Name" with the "\n" and append with the Security identifier when the name changes so that a new line with the Credit family name appears...

I have a unique problem. Securities data looks like this: Credit Family BB Internal PP or CUSIP 1166 AVENUE OF THE AMERICAS COMMERICAL MTG TRUST 682439AC8 1166 AVENUE OF THE AMERICAS COMMERICAL MTG TRUST 682439AE4 1166 AVENUE OF THE AMERICAS COMMERICAL MTG TRUST 682439AJ3 1166 AVENUE OF THE AMERICAS...

Ray,

It uses Open in the routine.

But this is happening only in QA and Prod regions. Dev box is working fine. That is why I was assuming that there is no issue with the routine.

I have been having issues with the Routine UtilityHashLookup in 8.5 server jobs. When the Hash files are created under /data/<Project_Name>/hash directory, the routine is not find the hash file when testing the UtilityHashLookup. But when the path is changed to /Projects/<Project_Name> then it is wo...

We are in the process of migration from 7.5 to 8.5. Some of the jobs are calling a MQ Sequence in 7.5. I am able to compile them after migration to 8.5 but at run time getting the fatal error: ds_loadlibrary: error in dlopen of mqs.so - libmqm.so: cannot open shared object file: No such file or dire...

Can't I have Drop Column1;
Drop Column2;
Drop Column3;
.
.
.
Drop ColumnN;

Is there a shortcut to DROP multiple columns.
Like if we want to drop column number 100 to 120 from the input link. Is there some notation we can do for that in Modify Operator?

I am trying to load to a Oracle table which has 150 columns and the control file for SQL loader is incomplete. I am seeing posts that refer to a patch but could not find any. So can anyone please post the link to the fixpatch or Patch number for this error? SQL*Loader-350: Syntax error at line 128. ...

Yes!!!! Changing to to Char(10) on both the links worked. One more thing the data is alphanumerical just an FYI so it can help others later on.

I changed the datatype to varchar(10) on both the source link and the lookup links and added APT_STRINGPADCHAR of 0x0. Still getting the same problem. So now going to change both of the links to Char(10) and try. Hope it works.

So I should include the APT_PADCHAR in the parameters and change the datatype to resolve this issue?

So I should include the APT_PADCHAR in the parameters and change the datatype to resolve this issue?

What does a resulting value of 0 mean when we do a lookup? I have an Underwriter_id(char 10) in Source. User_id(carchar 10) in lookup table. The data types are different. But the lookup is failing. But if I do it from the database then the match is there. So if the lookup action is drop then the rec...