DSXchange

I have a sequential file like 123456789XABC 123456789Y123 123456789Z456 123456789XGHI 123456789Y345 123456789Z786 AND MY OUTPUT SHOULD BE LIKE ABC123456789XABC ABC123456789Y123 ABC123456789Z456 GHI123456789XGHI GHI123456789Y345 GHI123456789Z786 Any suggessions/solution out there pls. Thanks in advan...

hi,

how to execute a shell script from datastage job?

explanation please

Naren

Could you please explain bit more

kduke wrote:I would use a shell script. I think it would be easier. You could also do this in routine. You can open any directory with "openpath".

Hi
Iam using the Folder Stage to retrive the file names of the folder. Based on the folder name I need to modify the file names.

Any suggessions/solutions

Hi,

Following will Solve your problem

EREPLACE(OCONV(@DATE,"DYMD[4,2,2]"),"/","")

Hi,

I need a date format like : YYYYMMDD,.

But when iam writing Oconv(@DATE,"DYMD[4,2,2]") IT GIVES THE OUTPUT LIKE YYYY/MM/DD.

How do i get the result in YYYYMMDD format.

Any help would be appreciate

Naren

Ray, How to implement this logic. How to increment the stage variable value?. Naren The routine is called once per row. You seem to have assumed it is called once per job invocation. The upshot is that you don't need either loop. A simple test is all you need to implement your logic. Indeed, you don...

Thank you verymuch If you want to exchange or replace substrings yourstring=CHANGE(yourstring, "XYZ", "ABC") will change all "XYZ" substrings to "ABC". If you want to map an array to other values: CONVERT "XYZ" TO "ABC" IN yourstring will c...

Hi,

Is there any function to get the number of instances of a substring in the string.

Any help will be appreciate.

Naren

Arnd I didn't get you. could you please explain bit more. Thanks Naren ... I am writing a routine like this.But it aborts after sometime. ... Loop While (Substrings(Arg1,26,1) = 'C') ... Is there anything wrong with my code? ... Yes, your loop "While" condition doesn't change; which either...

Thanks Arnd. Actually while testing routine, it got abort. I am writing a routine like this.But it aborts after sometime. FUNCTION SQNNUM(Arg1) Check = @True Ans = 0 Loop Loop While (Substrings(Arg1,26,1) = 'C') Ans += 1 If Substrings(Arg1,26,1) <> 'C' Then Check = @False Exit End Repeat Until Not(C...

Hi,

When Iam trying to open a Custom Routine will pop up a message like

"RECORD ROUTINENAME IN FILE DS_ROUTINES IS LOCKED BY ANOTHER USER".

But nobody opened that routine.

How do I unlock this routine?. Any suggessions would be appreciated?.

Thanks
Naren

Ray, Thanks a lot. Naren. The easiest way is to create a routine, and use the result of the routine (loaded into a stage variable, so you only need to execute it once) to constraint the output links. Here's one I baked earlier. FUNCTION IsDateStr(Arg1) * History (most recent first) * Date Programmer...

Hi,

How can I validate my inpute date format?.
my input date format should be 'YYYYMMDD'.
If not reject the row.
Any suggessions would be appreciate.

Thanks in advance.

Naren