Search found 8 matches

by Cutty Mark
Fri Dec 18, 2015 4:43 am
Forum: General
Topic: **VIEWDATA ROW LIMITER HIT**
Replies: 3
Views: 2357

Hi qt_ky

The issue is solved.

I have done a blunder.

While viewing data I have mentioned the skip count as 2000 (for my previous proj) and viewed. Hence I was unable to view. Now I noticed it and corrected :P :P .

Thank you for your help and sry for wasting your time.

Regards,
Cutty Mark
by Cutty Mark
Thu Dec 17, 2015 12:53 am
Forum: General
Topic: **VIEWDATA ROW LIMITER HIT**
Replies: 3
Views: 2357

**VIEWDATA ROW LIMITER HIT**

Hi I created a sample job in DS and tried running it to check a logic. The job ran successfully without any error i.e status is finished. However am not able to view the data neither in source nor in target. The error is viewdata row limiter hit in view data **VIEWDATA ROW LIMITER HIT** <_ABORT_IDEN...
by Cutty Mark
Fri Oct 16, 2015 3:26 am
Forum: General
Topic: Execute Command Actvivty
Replies: 8
Views: 4321

Re: Execute Command Actvivty

Thanku Naveen :)

I tried both ./{ScriptName}.sh and sh {ScriptName.sh} ways.
The script is not executing.

The only way working is ksh in command and passing file path as parameter.

:) :)
by Cutty Mark
Thu Oct 15, 2015 11:25 pm
Forum: General
Topic: Execute Command Actvivty
Replies: 8
Views: 4321

Execute Command Actvivty

Thanku for the response Chulett, MrBlack and qt_ky. I din run it in unix. However I changed the echo statement to return values i.e #!/bin/sh file="xyz/abc/mv.sh" if [-f "$file"] then return 0 else return 1 fi The script works fine. However when I pass the script loaction in comm...
by Cutty Mark
Thu Oct 15, 2015 4:20 am
Forum: General
Topic: Execute Command Actvivty
Replies: 8
Views: 4321

Execute Command Actvivty

Hi, I have a requirement to check whether a specific file exists or not. I used Execute Command Activity to call a script. However I dono what mistake I have made, the script is not executing. Getting below warning Error: JobControl(@Execute_Command_0):Command /xyz/exist.sh did not finish OK, reply ...
by Cutty Mark
Thu Oct 01, 2015 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Derivation
Replies: 6
Views: 2371

... with just a little added complexity if your definition of "does not have a value" includes the possibility of NULL. Yep. . . This is what I too tried. However, it was mentioned as 'If value doesn't exist in colomn(column_name)' . . . So am not sure what they mean. So waiting for the r...
by Cutty Mark
Thu Oct 01, 2015 1:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Derivation
Replies: 6
Views: 2371

Reply

Thanku rkashyap. . . :)
I used IsNull() and solved it.
Its working fine
by Cutty Mark
Wed Sep 30, 2015 2:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Derivation
Replies: 6
Views: 2371

Derivation

Can someone help me with a derivation to be written in tfm stage to pass value '_' if any value exists in column A and value '/' if no value exists in column A.
:(