Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Posts
    12

    Red face Unanswered: String Manipulation - Help

    Hi,

    I am a newbie to informix.I need to migrate some informix procedures to SQL server.As i am new to this,I cant figure out what does the following statement do..is it some kind of string manipulation...

    define sp_man_type char(1) ;
    define sp_in_man_id char(8);
    let sp_man_type = sp_in_man_id [ 1 , 1 ] ;

    if someone could explain it ,that would be of great help.

    Thanks in advance
    NivasKhan

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    let is used when you are going to calculate something.

    ex: let a = b+ c
    in this case a gets the sum of b and c...

    in your case, the first parameter gets the first character of the second parameter.
    rws

  3. #3
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Oh my God!!!

    You are migrating to SQL server and I am helping you????
    rws

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •