DSXchange

quote:Originally posted by datastagedummy
[br]Try using

If Len(Trim(Transform_Full_File.FNAME)) = 0 Then @Null Else Transform_Full_File.FNAME



I got the same result using that bit of logic...any other thoughts?

I am trying to use the trim function to help identify a blank string field and then with a If then Else statment trun it into a Null This is my code If Trim(Transform_Full_File.FNAME, "R") = '' Then @Null Else Transform_Full_File.FNAME Unfortuanatly it does not work, though it makes all th...

I actualy did all that you suggested and it worked!!! Thanx for the help Jim quote: Originally posted by danjm [br]quote: Originally posted by chulett [br]All you need to do is change some values in your Sequential stage. Scroll it over to the right and you'll see a (somewhat hidden) column labeled ...

I am trying to bring in a sequencial flat flile that is fixed width. The file format that I have brought into manager matches the file and I have made all the coloumns nullable. But when I run the job I get the following error: NewJobTemplate..BPPastImp.Import: read_fixedwidth() - row 3, column Nvoc...

Thanx Worked like a charm
Jim

quote:Originally posted by mhester
[br]Remove the END statement and it will compile. The END statment is confusing the compiler since this is a function.

Regards,

Michael Hester

I am trying to write a very simeple bit of code as follows quote: Harmitem = Arg1 Ans = '' If Harmitem = '116' then Found = @True else Found = @False If Found Then Ans = 'R' End when i compile the job i get the following errors quote: Compiling: Source = 'DSU_BP/DSU.JOCImportRedefinedReefer', Object...

I do also beleve that it should be in a table, but I did post a few questions regarding that as follows. also i have been pluggin through this code and have a question. this is a bit of code that i have writen quote: *-- (ATLANTIC FRANCE): If COUNTRY = '427' Then FOUND = @TRUE Else FOUND = @FALSE If...

Uggg. I need to get a better handle on all of this stuff. Ill go look for what you mentioned. Thanx Jim quote: Originally posted by mhester [br]Jim, As Ray stated you might want to edit the code and you may encounter a line in the code that looks something like - V0S1.Stagevar%%2 = If Pin%%V0S1P1.Co...

Thant makes all the sence in the world to me. I do understand that, but what happens when I have to mix the criteria, ie in these ultports, and this sline, and this country all make up the trade? I do have instances when I have to address that. Jim quote: Originally posted by kcbland [br]By looking ...

Next time you have a spare min. could you please answer a few questions about your Table suggestion...seeing how it makes alot of buisness sence. Our logic requires a different number of fields to be checked based on the Trade..IE Pac needs Ultcode, Ultname, USCode. But another trade may only need U...

WOW!! there is something to think about...Ill get back to you on this :) Jim quote: Originally posted by kcbland [br]While I have a spare minute, I'll elaborate why your problem should be dealt with via a table. My guess from looking at your SQL is that you are attempting to categorize items by cert...

I think that i am finaly getting a handle on all of this...Now just to learn DS Basic...I am reading the manual now...Fun reading I tell you. Thanx for all the help Jim quote: Originally posted by kcbland [br]Create your function in DS Manager. Make sure you compile it. In your DataStage job, go to ...

you make a good point. so for arguments sake lets say that i have a routine that does what I want (wich is almost true because a user of this forum was kind enough to give me a sample with my own code) do i put that call into the dirivation of a stage procedure? how do i use the routine once its cre...

So basicaly this method will not work....I have not seen any way to put an array into a stage variable...but i could be wrong. But im just confirming that this will not give me the answer that I need..correct? Jim quote: Originally posted by kcbland [br]The usage of COUNT is wrong. It will give subs...

This is the full error code. quote: DataStage Job 13 Phantom 948 Program "JOB.1730727197.DT.1304256656.TRANS1": Line 175, Improper data type. Attempting to Cleanup after ABORT raised in stage JOCPOPDEVSTEP1Test..Apply_Bussness_Rulles DataStage Phantom Aborting with @ABORT.CODE = 3 This is ...