DSXchange

Can anyone help on the following case. Thanks a lot!!!

I have a date field and want to calculate the date after 24 month, does any function exist in Transformer or any other else ?

I have a report in following format
The negative sign is in the trailing position and there is comma inside the string, I would like to know what 's the best solution to convert this string into Decimal

Thanks in advance.

I have built a DS server routine named "GetLatestJobLog" to retrieve DS job log and call it in each job 's after-job-routine. It will use jobname as filename and write to given path. We are using PX 7.5 on UNIX. I would like to know how I can save or retieve job log after the new version o...

I have encountered similar case too, it is not "!", but ">". What 's worse is it didn't convert to another character, but lead to incorrect mapping NLS was enabled, with "Project default (ISO-8859-1)" in client. Do you have NLS enabled and, if so, what client character ...

If it is not a one-character regular expression, how to code the LIKE clause ?

srk, you are using BuildOp, right ? You 'd better have a look at this file $Proj Dir/buildop/operator.apt, after imported the custom stage, you need to update this file too. Have a try and let me know your result. Hi, We are having some custom stages that are required to be imported and then needs t...

Problem solved, FYI

The workaround is to copy the file generated in the buildop folder (project folder) into the target project accordingly.

Only copy the operator file (*.o) and definition file (operator.apt) is enough.

madhukar wrote:hi all,

How to create empty data sets?
And how to clear the existing data in a dataset?

regs
Madhukar

Row Generator is the esay way

I would like to know if there is any way to export an executable BuildOp and then import to another project or machine. I have tried to use Manager Export, but it seems that it can only export the source, need to export the table definition too, and then need to be re-generated in the new project or...

Kirtikumar, Have you solved this problem ? Ray, There is Macro APT_MSG in "PXEngine/include/apt_util/message.h", do you know how to use it ? APT_MSG(MessageSeverity, englishString, args, logOrSourceModule) For "logOrSourceModule", what is the possible value ? Thanks all of you.

Ray, How to include this Header file (*.h) into BuildOp ? I code as following #ifndef DSD_GCI_H #ifndef DATUM #define DATUM long #define DBFILE long #define HANDLE long /* #define BITMAP long */ typedef struct tagSTRING { unsigned int len; unsigned char* text; } STRING; #endif /* DATUM */ #define h_...

But the result is the same as only [suppress_zero]. e.g. A Decimal(5,0) 123 I want "00123", not "123" or " 00123." Good point! I posted without testing it first. Your original syntax was correct and my correction was incorrect. You should use [fix_zero, suppress_zero] i...

Job Aborted. main_program: Error parsing modify adapter: Error in binding: Expected '(', got: "[" Expected destination field selector, got: ")"; input: C:string[7] = string_from_decimal[fix_zero][suppress_zero](B) ; No, as per the documentation: stringField = string_from_decimal[...

You mean ? C:string[7] = string_from_decimal[fix_zero,suppress_zero](B) I would like to know how to use fix_zero option, but without leading space and trailing decimal point. Would you please give me a sample, thanks a lot. Simply add the word surrounded by square brackets in your specification. Add...

vmcburney, Thanks your information. If I would like the string with fix_zero case, how to handle ? Let me make it even easier for you. E:string[7]=string_from_decimal[suppress_zero](A) The suppress_zero option is not documented anywhere in the Parallel Job Developers Guide but it is in the Orchestra...