DSXchange

prasad111

novneet wrote:In that situation the test data that u have posted is wrong. As there are spaces for the numeric columns(that to in between two numbers of same field).

The data is not a problem, so do I need to change the numeric into varchar is that you are telling????

prasad111

novneet wrote:Do you actually have spaces in the data or is just for the representation purpose you have put the sapces?
Please verify the data as per the metadata you have provided.

Yes there is a space in the data, I have not written it manually

prasad111

Your DATA are wrong. Misaligned. You have to fix this. ... thats a copy paste mistake from my side, sorry the data format is XYZABCDEF MS060000000 116707096ABCDET QWER ASDER 0001250 CT 1 000000 XYZABCDEF MS060000000 1167072007-03-2600226 00000 0000226 XYZABCDEF MS060000000 1167070752890500080000100...

prasad111

ray.wurlod wrote:Set the Width property (rather than the Max_Width property) for col3. And for col8, even though that's unrelated to the exact problem reported. ...

I changed it, is that because the SQL Type was Varchar??
as you said, nothing related to the prolem. I am getting the same error mentioned

prasad111

Hi All, I was reading a seq file in PX, seqfile------->transformer-----> seqfile in properties tab: File = path Read Method = Specific File options default In format tab: Record level Record Length = fixed Field defaults Delimiter = none Type defaults General Field width = 91 {these many data will c...

prasad111

DSguru2B wrote:Well the permissions look fine. I am running out of ideas now. I guess its upto you. Put a bunch of echo statements in both your scripts. These statements will show up in the log. See how far it goes without breaking.

The path names had some problem.

prasad111

At a glance the scripts look fine. Just make sure that both scripts have permission to be executed by your datastage id. It looks like this -rwxrwxrwx 1 atgr atgr 1239 Mar 9 16:38 filelist.sh -rwxrwxrwx 1 atgr dstage 2478 Mar 12 09:51 Extract.sh Extract is the main script and filelist.sh is the scr...

prasad111

DSguru2B wrote:I hope you are initializing all the variables ($) inside your script. The script looks ok. Post your entire script please.

Main Script

Code: Select all

#!/bin/ksh

###############################################################################

prasad111

Handle all errors inside your script and exit explicity using a return code of 0 for successful and 1 unsuccessful. Yes I am using the return code [#parameters declatation - = script continues ------- when I am executing outside DS Job(UNIX command prompt) it executes fine, when I execute from Exec...

prasad111

You have 'Automatically handle activities that fail' turned on and your command did not return a zero result - so it was considered to have failed. Either turn off that option or read in the Help how to use two triggers to convince the Sequence job that you are handling the 'failure'. Thanks for th...

prasad111

Hi I am executing a shell script from Execute command stage. In General Tab --> Stage name In Exec Command --> I have the unix path and the shell script (/inbound/scripts/abc.sh) That is the only stage I am using in the sequencer, when I run this I am getting the error like JobControl (@Execute_Comm...

prasad111

prasad111

Hi,

I am reading XML file from UNIX path and using XLST to transform into the desired output format. Is there any way I can do the transformation in the output format(not same as the input format) without using the XLST code?
Is yes please let me give me some idea how to do that.

Regards,
Prasad

prasad111

Check the size of the folder where RT_STATUS and RT_..............files store, if it is full(hardisk space) then you will be not able to execute the datastage job. Otherwise, clear the log files of the datastage job which created this error and rerun it only for 10 records and check it ................

prasad111

Or if you want to avoid adding the hash file to VOC. Make a copy of UtilityHashLookup and change the command given after comment * Table is not in cache of opened tables, so open it. Change From: Open HashTable Change To: OpenPath HashTable You are now good to go, no hasle of adding the hash file t...

DSXchange

Search found 173 matches

Fixed width in Seq file

Execute Command - Shell script execution error

--

XML - XLST

Re: RT_CONFIG403 error, RT_STATUS389 from DS Server